Home |
Search |
Today's Posts |
#1
|
|||
|
|||
consolidating workbooks
Hi!
I have two xls files for the reporting, both identical apart from the numbers in the various cells. Each file has 10 different workbooks containing text, number and formula cells. I have to merge/consolidate these files to get the sum of all data. I already tired the "consolidate" function in the Data menu but that doesn' work because i loose the text and the formatting. I would also like to keep the formulas in the new file/workbook but instead i only got numbers using "consolidate". Is there a way I can easily copy and consolidate everything or do I have to copy formula and text cells and then consolidate or sum up the other cells manually??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions | |||
Consolidating multiple workbooks | Excel Worksheet Functions | |||
Consolidating data from different workbooks | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |