Thanks everybody for the suggestions.

I haven't tried them because after posting I finally figured out another
way. What I did was use the formula for
transpose (array)
and then follow the directions hitting F2 then CTRL+Shift+ Enter

Thanks again for your responces!!



"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