I have a bidding template I use as cost buildup to price the ships that work for my company.
There are 8 tabs with data and formulas that are interlinked, though not all tabs link to each other, some do. A summary tab however is linked to all of the other 7 tabs.
Each tab has from ~70 to ~200 rows of data with ~10 to ~20 columns, some of the tabs are formatted similarly but not identical.
This is a template for one ship, I would like to copy it down each tab and retain the relative references so it reads and writes to the new pasted copy of it below and I can edit it - for another ship and another down each tab.
I have done this but none of the relative references work, even if copying all from cell A1 in row 1 to cell A400 in row 400 accross all of the tabs, it does not retain the correct relative cell referencing.
In the attached file, I manually fixed the 2nd entire copy starting at line 101, which is 4 lines below the header and data is then aligned - in the Summary tab, and then tried to copy that down to line 400. There must be a way to keep from having to manually fix all of the relative references again? I'm not concerned with the few fixed references, I can quickly change those and have not decided if they should apply to the entire tab in any case.
I may want to add another 5 to 10 data sets as such and manual editing seems the wrong way to do this.