I would like to merge 4 workbooks into a master workbook. I would like for the information to update with new information that has been added to the source workbooks when it is open. The range in each workbook will vary and continuously increase. These are tracking workbooks. There are two tabs in each workbook. The source workbooks have the same columns as the master. I have copied the vba code recommended in other post but unsure how to change to meet my needs. Also when I run the code it opens a new workbook.
-
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.
Combine excel workbooks into master workbook
- Thread starter mshunt13
- Start date
