Try this non-volatile approach:

=INDEX('AUT 150 MHz'!$9:$9,ROWS($1:2))

Copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PboB" wrote in message
...
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