Referencing Sheets in a Formula

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

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
 
Top