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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,119,084
Messages
5,576,015
Members
412,694
Latest member
Deaf1Too
Top