Hi All,
I have 150 workbooks (very small in size) in a folder with the same column heading (PFA a sample). Can you help me develop a macro to consolidate all the workbooks. The logical flow should be
1) Open the folder
2) Open the first file
3) Copy from second row till the last filled in row. Excluding Column B (Please note there might be empty rows in between)
4) Repeat 2 and 3 for the seond file and so on.
Please note:-
A) It would be really helpfull if I need to only mention the folder name and not the different Workbook names (150 different workbook names)
B) I would like to exclude column B from all workbooks while consolidating
B) For all work sheets the last filled in column is E
C)The first and last filled row can vary from workbook to workbook
PFA a sample file
Bookmarks