Excel97: Are relative worksheet references possible?

[MichGovTech1]

Getting a backlog value from one worksheet to the next is easy enough, but if you want to generate upwards of 200 sheets, a large number of calculations per sheet gets real tedious real fast.<br>
Assuming all the calculations are the same on each worksheet, an easy way to solve the problem WOULD BE to simply copy the sheet's contents to the next sheet, but Excel keeps the worksheet name constant so that the references on (newly-copied) Sheet3 refer back to Sheet1 instead of Sheet2.<br>
<br>
Anyone know of a way to make inter-worksheet references relative (=S[-1]RC[6]) instead of absolute (=Sheet1!RC[6])?

 

[Dreamboat]

I don't recall whether relative worksheet references are available. However, after you have pasted your cells, you can do an Edit-Replace to Find Sheet1! and replace it with Sheet2!. Don't select either &quot;match case&quot; or &quot;find entire cells only&quot; boxes in find/replace dialog.