Avoiding Reference errors when deleting and adding new worksheets

[johannagh]

I have several worksheets that compile and summarize the data from
different bond deals which each have their own worksheet. (In example,
I have worksheets named Combined, Outstanding, and Capacity that sum
the numbers from worksheets Issue A, Issue B, Issue C etc.)

I would like to be able to delete and add new bond deal worksheets
without having to change the formulas on the other worksheets.

Can anyone please suggest a function or way to set up the summary
worksheets up that won't give me #REF! errors everytime I delete and
add in a new bond deal worksheet?

I appreciate any help.

Thank you!

 

[Bryan Hessey]

It would be easier to amend the formulas before deleting th
worksheets.

In Edit, Replace, Replace (tab), find BondSheet1, replace wit
BondSheet2, look in Formula, and Replace All.


Optionally you could retain the worksheet and Copy, Paste all data fro
the new to the 'old' (current) sheet.

Hope this helps

--