filter and copy data from different file to one excel using vba

Status
Not open for further replies.

thomsonreuters

New Member
Joined
Dec 9, 2017
Messages
26
Hi

I want to filter the data from each file and consolidate in to single excel my file name, sheet name and filter criteria are mention in column B, C and D. want to maintain same order based on filter creteria.

e.g:
Below table present in current sheet and needs to consolidate in the active sheet number 3

Can anyone pls help on this...urgent one....

thanks
JP

FIle name - Column BSheet name - Column CFilter criteria - - Column D
PB3-ALL-20_SAVIG.xlsxSAVIG QC CheckedWO2020060735
PB3-ALL-20_KPUSH.xlsxKPUSH QC CheckedUS2020095665
PB3-ALL-KIRAN.xlsxSAVIG QC CheckedUS2020094354
PB3-ALL-20_SAVIG.xlsxSAVIG QC CheckedUS2020098496
PB3-ALL-20_KPUSH.xlsxKPUSH QC CheckedUS2020098497
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,653
Office Version
  1. 365
Platform
  1. Windows
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,278
Messages
5,571,282
Members
412,374
Latest member
Nagelgal
Top