![]() |
Combine two workbooks into one
I'd like to set up a macro to combine two seperate workbooks into ONE
workbook. Here's the scenario. We make spreadsheets for clients that make purchases from us that hold relevant information to that specific buyer and save it named "[buyer] - [lotnumber]". Buyer and Lotnumber are named ranges in the workbooks that contain information. Because we're collecting a lot of information these days (and they refuse to let me go to a database), it's become easier to do updates to all of these workbooks by splitting them into two seperate workbooks. So now, the consultants will open these two books (named universal.xls as it contains sheets that are relevant to each buyer, and CORE-[model].xls because they pertain to a certain class of buyer). Once they have the universal workbook open they'll open the relevant core workbook, enter all the data and from there... they'll want to save. It would be much easier if they could save both the universal and core workbooks in one file. I'll leave the save location up to the consultant, I just need the code to combine both of those workbooks. The tricky part is this. The unviversal workbook will always be "universal.xls", however the core workbook will vary because of the "model" extension at the end (ie "CORE - Penington.xls, CORE - Brighton.xls", etc.) |
Combine two workbooks into one
FYI, I'm using Excel 2003
|
Combine two workbooks into one
Take a look at this:
http://www.rondebruin.nl/summary.htm Regards, Ryan--- -- RyGuy "btate" wrote: FYI, I'm using Excel 2003 |
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com