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???