Fromula Copying

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I want to copy a formula that contains a link from a
different worksheet down a column, and not have it
automatically adjust the column number as it goes down,
but instead increment the Sheet number, while keeping the
column number the same. Tall order huh?
 
Dan

Entered in A2 and copied down.

=INDIRECT("Sheet" & (ROW()-1) & "!cellref")

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Array VLOOKUP lookup_Value does not increment 3
Copy columns and paste with blank column between 5
Copying a formula to a range 2
Fill Down based on count in another sheet 2
Search other sheets for numbers & color them 10
Excel 2007 and Security key cards 3
Code copies twice...? 13

Back
Top