Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging multiple workbooks with crosslinked formulas into single f
I've been using a set of 6 workbooks for various inventory tracking tasks,
with multiple worksheets in each workbook, and all using formulas that link to data in other workbooks and/or worksheets. I've found various solutions for merging basic workbooks into a single workbook, but nothing that seems to fit my particular setup - I'm about to upgrade to Office 2007, and want to consolidate these workbooks into a single file, eliminating the extra files, while maintaining the formula links to the proper data in the new file - the merge solutions I've found and tried that keep the formula references keep the fomulas linked to the old files, rather than updating the reference link to pull the data from where the data was placed in the new file. I know this probably sounds a bit confusing, but would appreciate any suggestions on how to go about doing this, as it would save a ton of time vs having to manually go through the files to rebuild them as one. The files had to be split originally for ease of flash drive transport and use by multiple personnel, but now that I've got central network storage at work, its an unnecessary complication, and merging the files would make it far easier to pass inventory control on to somebody else... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging or Consolidating Data from Multiple Workbooks | Excel Discussion (Misc queries) | |||
Merging multiple workbooks | Excel Discussion (Misc queries) | |||
Creating a single workbook from multiple workbooks | Excel Discussion (Misc queries) | |||
Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) |