I have a workbook with multiple sheets that have been copied and linked from master sheets so that I only have to make changes to the master and it will update the sheets in this workbook.
My problem is that I want to make a totals page in this new workbook that totals the values from the linked sheets formulas which at this point is showing the name of the workbook and cell reference where it got the data from.
I hope I'm explaining this clearly enough.
Is there a way to do this?
My problem is that I want to make a totals page in this new workbook that totals the values from the linked sheets formulas which at this point is showing the name of the workbook and cell reference where it got the data from.
I hope I'm explaining this clearly enough.
Is there a way to do this?
