Drag it down a few blank rows, then cut and paste the resultant formulae to
the columns where you want them.

"carrera" wrote:

> my formula is
>
> =2244!$S9 (2744 is the name of the sheet I'm taking info from)
>
> I'm needing to cut and paste this formula into a cell a few columns down so
> it will read.....=2744!$S10
>
> Then further along...-2744$S11 and so on.
>
> I cannont drag the formula has there are other formulas in the columns in
> between.
>
> Thanks