Relative Worksheet Reference

[donkirk]

I have an Excell 2003 workbook with (currently) only two workheets. Th
second sheet pulls data from the first sheet using a simple
='worksheet (1)'! $X$N formula.

When I make a copy of sheet 2 and move it to the end, the results fro
these formulas in sheet 3 pull the data from 'worksheet (1)'. What
WANT it to do is pull the data from the preceding sheet ('workshee
(2)'.

What do I need to do so that copied sheets (I need to have about 30 i
the book) pull the data from a Relative worksheet referance (th
preceeding sheet) rather than an Absolute worksheet reference(th
original sheet that the copies are made from).

Don Kir

 

[davidylam]

I am not sure you can use relative for worksheet as you describe.

I suggest you just do a find and replace.Sheet1 -->Sheet2

As you indicated if there is a lot of worksheet, you could do a macro
for the replacement.

Good Luck.

 

[davidylam]

One thing I forgot to mention is VBA does take worksheet int
consideration.

To test record a macro and create several new worksheet and take a loo
at the code.

Good Luck

 

[donkirk]

david

Thanks for the tip. I'll let you know how it goes

 

[Frank Kabel]

Hi
see: http://www.google.com/groups?selm=uNDmzFfUBHA.1216@tkmsftngp07