Hello all. I'm not sure what I need to do to fix my problem.
I had a master data template which I copied and renamed with different entity names. So all worksheets are basically equal as far as setup and formulas, except for the numbers input.
Workbook 1: has 1 data input sheet.
Workbook 2: has 2 data input sheets and one sheet to consolidate the data from 1 and 2. It also, has 2 more data input sheets and another consolidation of the first consolidation sheet and the second set of 2 data input sheets. So 6 sheets in total - 4 data inputs and 2 consolidations.
Workbook 3: has 2 data input sheets and one sheet to consolidate the data from 1 and 2.
So yesterday I entered financial data into Workbook 1 (The other 2 workbooks are basically still just templates). T
Today I had to add/delete some rows, remove highlighting from a row, rename some row titles, and group some rows.
I am trying to avoid having to go into the other 9 sheets and recreate the changes I had made in the first workbook. When I tried to copy the the sheet to the other 9 sheets all the formulas referred back to the first workbook sheet. Is there an easy way to update all the sheets without affecting the formulas?
Thank you
I had a master data template which I copied and renamed with different entity names. So all worksheets are basically equal as far as setup and formulas, except for the numbers input.
Workbook 1: has 1 data input sheet.
Workbook 2: has 2 data input sheets and one sheet to consolidate the data from 1 and 2. It also, has 2 more data input sheets and another consolidation of the first consolidation sheet and the second set of 2 data input sheets. So 6 sheets in total - 4 data inputs and 2 consolidations.
Workbook 3: has 2 data input sheets and one sheet to consolidate the data from 1 and 2.
So yesterday I entered financial data into Workbook 1 (The other 2 workbooks are basically still just templates). T
Today I had to add/delete some rows, remove highlighting from a row, rename some row titles, and group some rows.
I am trying to avoid having to go into the other 9 sheets and recreate the changes I had made in the first workbook. When I tried to copy the the sheet to the other 9 sheets all the formulas referred back to the first workbook sheet. Is there an easy way to update all the sheets without affecting the formulas?
Thank you