I have a main spreadsheet with about 100 rows where the individual cells contain links to a variety of different tables on different worksheets. I am creating a number of duplicate main spreadsheets but as I create them I want the link to go to one row lower than that in the original. Other than changing all the formulas manually is there anyway I can get the cells on the new sheet to point to a row lower than the main sheet?
Bookmarks