adding all files data in one

[vikas_newports]

Hello

I have lot of files from where i need to copy some cells (do filter too) and paste into one master file (AIO file name).

let me show u example work from sample 01 file.

1: Copy Cell A9 and paste into B2 Cell of AIO workbook
2:Apply Filter on Row 10 and Filter Greater Than Zero on H10 (Total Due).
3: Copy Filtered Data From Column A Without Header to E2 cell of AIO Workbook
4: Copy Filtered Data From Column H Without Header to F2 cell of AIO Workbook

I am sure someone will help me via macro or other solution.

[jindon]

Please Login or Register  to view this content.

[Bo_Ry]

Please try Power Query

Change the Sample folder in Red if needed

Please Login or Register  to view this content.

[vikas_newports]

Thanks Jindon its working fine.

[jindon]

1: Copy Cell A9 and paste into B2 Cell of AIO workbook
2:Apply Filter on Row 10 and Filter Greater Than Zero on H10 (Total Due).
3: Copy Filtered Data From Column A Without Header to E2 cell of AIO Workbook
4: Copy Filtered Data From Column H Without Header to F2 cell of AIO Workbook

.................

[vikas_newports]

how to fix path if it is changes every month or user changed every month

Please try Power Query

Change the Sample folder in Red if needed

[Bo_Ry]

Power Query can read through subfolder

Put any file in subfolder eg:

D:\Sample\Jan\*.xlsx
D:\Sample\Feb\*.xlsx