Referencing Sheets in a Formula
 

Is there a way to change sheet numbers when cells are copied down? What I
mean by this is:

I have five sheets labeled Sheet1 through Sheet5.

I have the formula =INDIRECT("Sheet&ROW()!",$A$1)

As I copy down I want the Sheet Numbers to correspond with the row numbers
that contain the formula. I want the cell A1 to be referenced from each
sheet every time.

Thanks in advance for any help you can offer.

Chris

Hi Chris

try
=INDIRECT("Sheet"&ROW()&"!$A$1")

Cheers
JulieD

"Christopher Anderson" wrote
in message ...
Is there a way to change sheet numbers when cells are copied down? What I
mean by this is:

I have five sheets labeled Sheet1 through Sheet5.

I have the formula =INDIRECT("Sheet&ROW()!",$A$1)

As I copy down I want the Sheet Numbers to correspond with the row numbers
that contain the formula. I want the cell A1 to be referenced from each
sheet every time.

Thanks in advance for any help you can offer.

Chris