Hi! I want to combine data in multiple worksheets into one master worksheet in a separate workbook. All files are located in the same folder, so it would just need to loop to copy/paste into the master workbook's combined worksheet. I would like to house the macro in a separate workbook. Any help is appreciated. Below are screenshots of the folder with all of the workbooks and the Master Workbook. Files export_1-2 through export_T need to be copied into the worksheet named Combined_Results in Combine_Susp_Qry_Results.xlsx Any help is appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA Code to Combine Multiple Workbooks into one Worksheet
- Thread starter BrittKnee
- Start date
Excel Facts
Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Jrohira2004
New Member
- Joined
- Feb 3, 2019
- Messages
- 3
Hi,
on the above macro i also need the name of the workbook from which data came. i have 7 workbooks - i need to consolidate data and then enter the name of workbook in last column.
Also is there i a macro to pick only headings which are common across all workbook
on the above macro i also need the name of the workbook from which data came. i have 7 workbooks - i need to consolidate data and then enter the name of workbook in last column.
Also is there i a macro to pick only headings which are common across all workbook
Upvote
0
