There is a free Excel add-in that may do this for you.
RDBMerge, Excel Merge Add-in for Excel for Windows
There is a free Excel add-in that may do this for you.
RDBMerge, Excel Merge Add-in for Excel for Windows
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you for your quick reply AlphaFrog...
The addin seems very useful however given the current circumstances we have very limited resources and are not allowed to install external/additional addins.
Thats what made me think of a macro that would ask for a path where all the excel workbooks are saved and then copy all the data in the worksheets in one master data sheet.
Thank you again for your valuable input... I will surely add this addin in my personal desktop.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks