Forum Discussion
Erica Visser
Sep 23, 2018Copper Contributor
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 ...
- Sep 23, 2018
pls see attached file.
hope this is what your looking for.
thanks..
Lorenzo Kim
Sep 23, 2018Bronze Contributor
pls see attached file.
hope this is what your looking for.
thanks..
Erica Visser
Sep 24, 2018Copper Contributor
Hi Lorenzo
Yes that is what I am looking for.
How do you do it using the consolidate function
- Erica VisserSep 24, 2018Copper ContributorSorry Lorenzo, my computer did not download the file correctly the first time, when I did it again I could view it properly.
Thanks for the help