开发者

Excel VBA function that returns all data to a new sheet

开发者 https://www.devze.com 2023-03-13 04:33 出处:网络
How can开发者_如何学Go I create a function that will apply predefined filters etc, and then generate a new sheet with that data?

How can开发者_如何学Go I create a function that will apply predefined filters etc, and then generate a new sheet with that data?

I just need the create new sheet part. Thank you.


Use a predefined template sheet and make a copy:

Dim wb as Workbook
Set wb = '... (set the workbook here where you want your new sheet to be copied)
ThisWorkbook.Sheets("NameOfYourTemplate").Copy _
  after:=wb.Sheets(wb.Sheets.Count)
0

精彩评论

暂无评论...
验证码 换一张
取 消