Referencing Sheets in a Formula

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF function and cell /sheet reference 3
Indirect formula not working if I give custom name for Sheets 1
change formula- keep cell increment sheet numbers 3
sumproduct of multiple sheets 5
When referencing other Sheets 1
Referencing the same cell on multiple sheets 1
CountIf formula problem when referencing a column. 4
formula referencing a column -> autofilling in a row ??? 2

Top