There are about 500 workbooks and in each workbook there are 11 sheets which should be consolidated as per Tab name need a macro (VBA coding) for the same.
All workbooks are in the same folder. Is it possible. Thanks in advance.
There are about 500 workbooks and in each workbook there are 11 sheets which should be consolidated as per Tab name need a macro (VBA coding) for the same.
All workbooks are in the same folder. Is it possible. Thanks in advance.
If you are running xl2010 or later, you may have luck using Power Query consolidating your files.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks