Relative Worksheet Reference

  • Thread starter Thread starter donkirk
  • Start date Start date
D

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).

:confused: Don Kir
 
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.
 
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
 
Back
Top