Microsoft Excel formulas???

Question

Ok, I have an excel spreadsheet with numbered tabs to document payments. I have got up payment 17 and now my tabs have run out. I want to make more tabs ready for more payments up to about 25 however, the forumlas on each cell refer to the previous payment (refrence the preious tab). i.e amount previously certified.

How do i create new tabs with already referencing formulas because at the moment I am creating a copy of the tab and then manually changing all the cell references in all the formulas and its taking for ever!!!

Any help??

Answer 1

easiest way I can think of use the "find & replace" feature (CTRL-H) or under the "Edit" menu as well.

copy your #17 sheet (which has references to your payment 16 sheet).  then "find" (in formulas) the references such as "Payment16!" and replace with "Payment17!"

Answer 2

numbered tabs to document payments up payment 17 and make more tabs ready for more payments up to about 25,  the forumlas on each cell refer to the previous payment (refrence the preious tab). i.e amount previously certified.

create new tabs with already referencing a copy of the tab then aall the formulas.

Answer 3

If it is just referring to one sheet then create a copy of the sheet and then find the old reference sheet name and replace is with the new one using Find and Replace option.