malleshg24
10-13-2019, 11:58 PM
Hi Team,
Need your help , I am collating all files from a folder with specific headers using advanced filter method.
Firstly I am Opening each file applying advanced filter, taking helper sheet for pasting filtered data.
and then copying helper sheets Data into Masterworkbook.
Can we shorten the code by taking header_row in memory. Attached my attempted workbook.
Datawbk.Sheets(1).Range("a1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=ThisWorkbook.Worksheets("Header_Row).Range("a1:c1")
Regards,
mg
Need your help , I am collating all files from a folder with specific headers using advanced filter method.
Firstly I am Opening each file applying advanced filter, taking helper sheet for pasting filtered data.
and then copying helper sheets Data into Masterworkbook.
Can we shorten the code by taking header_row in memory. Attached my attempted workbook.
Datawbk.Sheets(1).Range("a1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=ThisWorkbook.Worksheets("Header_Row).Range("a1:c1")
Regards,
mg