Forum Discussion
Solved
Consolidating data from multiple worksheets
Hi When Excel does a consolidation from different worksheets and the "Create links to source data" is ticked it will put the Workbook name in summary sheet and even though the sheets have different ...
pls see attached file.
hope this is what your looking for.
thanks..
Lorenzo
How did you get the Row Names into Column C and the product name into Column B on the summary sheet. Was this added manually?
I added a sheet called "Erica Test" did exactly the same in the consolidation function as you did but the result looks different. The values are the same but the row labels and columns gets grouped and no row labels pull through?
What am I missing?
look at sheets Dotsure, brokers, binders - there are formula there - being referenced by the summary sheet.
glad it helped..
glad it helped..
pls see attached file
- by the way, I did not use consolidation function, just used cell reference formula...