Hmm... Good point! I suppose we may as well take it even one step further,
and eliminate the +1. ROW(A2)


"pinmaster" wrote:

Or.... ROW(A1)+1 or ROW(1:1)+1 then you wont need to adjust.

Cheers!
Jean-Guy

"Elkar" wrote:

This formula should work for you:

=INDIRECT("'AUT 150 MHz'!"&ADDRESS(9,ROW()+1))

This assumes your formula is placed in row 1 of your second sheet. If
you're starting in a different row, then adjust the ROW()+X portion
accordingly. Where X = the difference between the row number the formula is
in and 2. So if you start in row 15, you would use ROW()-13

HTH,
Elkar


"PboB" wrote:

In a column have the forumla
='AUT 150 MHz'!B9
I want to drag this down the column but have it change the source column not
row.
Example:
='AUT 150 MHz'!B9
drag down to get
='AUT 150 MHz'!C9
='AUT 150 MHz'!D9

What I am getting is
='AUT 150 MHz'!B9
drag down I get
='AUT 150 MHz'!B10
='AUT 150 MHz'!B11

Thanks