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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,340
Members
414,059
Latest member
Amro El ghazawei

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top