Hi!
Here's one way:
=INDIRECT("S"&ROW(A40)&"!$W$5")
Which evaluates to:
=S40!$W$5
As you drag copy down:
=S40!$W$5
=S41!$W$5
=S42!$W$5
=S43!$W$5
etc..
Biff
-----Original Message-----
I have a question about using sheet names in a formula.
I would like the
sheet name to go up by one page for each row I put the
formula in...(ie)
13A reads (="S40'!$W$5)... I need to have row 14 read
(='S41'!$W$5)
There are many many worksheets...260 in all that need
this on them. Each
worksheet is about 300 rows long. How can I do this
without having to change
the sheet name by hand???
Any help is greatly appreciated!!!
.
|