View Single Post
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

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