Hi All
Hope all is well.. I need a favour please.
[FONT=arial, sans-serif]I have a number of excel under one folder where I have to consolidate all of them in one file. There could be 10’s tabs in each workbooks however macros should look at only 2 tabs in all the workbooks eg: tab 1 and tab 3 and consolidate accordingly ( please note consolidation file should have only 2 tabs to consolidate). Data will have a similar format and number of rows. I also wants to consolidate without having to open the file. As and when we add the file in to the folder it should consolidate without having open the files by looking at those 2 specific tabs.[/FONT]
I can add here a file with example? I hope you will have time to help me. I just moved to a new role having this in my plate would help me a lot.
Sorry to bother appreciate your response.
Regards
Arshad
Hope all is well.. I need a favour please.
[FONT=arial, sans-serif]I have a number of excel under one folder where I have to consolidate all of them in one file. There could be 10’s tabs in each workbooks however macros should look at only 2 tabs in all the workbooks eg: tab 1 and tab 3 and consolidate accordingly ( please note consolidation file should have only 2 tabs to consolidate). Data will have a similar format and number of rows. I also wants to consolidate without having to open the file. As and when we add the file in to the folder it should consolidate without having open the files by looking at those 2 specific tabs.[/FONT]
I can add here a file with example? I hope you will have time to help me. I just moved to a new role having this in my plate would help me a lot.
Sorry to bother appreciate your response.
Regards
Arshad
