OH! My lightbulb turned on, thanks

yeah, I didn't know about transposing.

Actually, it got a little stickier because I realized I had to separate
every other column (too long to explain, has to do with modalities of
treatment)

But....It did end up working, thanks!

"bigwheel" wrote:

> Pretty much like I thought the first time round. Perhaps I could of
> explained the idea a bit better. Ok, in a blank part of the worksheet or
> even on another worksheet, enter the formula =2744!$K9 select the cell and
> drag down by the little square in the bottom right corner. You should end up
> with =2744!$K10, =2744!$K11, =2744!$K12 etc in the same column. Repeat in
> the cell to the right of the formula =2744!$K9 but changing it to = 2744!$P9.
> Again drag that down to produce the series. Repeat as many time as required.
> THEN, select by row to include the formulae =2744!$K9, = 2744!$P9, =
> 2744!$U9, = 2744!$Z9 and copy then at the column that you want the formula to
> appear i.e. C7 select Paste Special>Transpose and you should end up with the
> result you desire. I did!!
>
> "carrera" wrote:
>
> > well, ok, but it's going to sound pretty much like my original question......
> >
> > in C7 is the formula =2744!$K9
> > in C8 is the formula = 2744!$P9
> > in C9 is the formula = 2744!$U9
> > in C10 is the formula = 2744!$Z9
> > and so forth.....
> >
> > I need to move these formulas to intermitent columns (F, I, L, O etc)
> > so that....
> > in F7 the formula is =2744!$K10
> > in F8 the formula is =2744!$P10
> > in F9 the formula is =2744!U10
> > in F10 the formula is =2744!Z10
> > and so forth.....
> >
> > Column I would need to reflect the same formula, except for row 11
> > Column L would need to reflect the same formula, except for row 12
> > Column O would need to reflect the same formula, except for row 13
> > and so forth......
> >
> > So, as I originally asked, I am needing to cut and paste the formula from a
> > cell that reads =2744!$K9 into a cell several columns down, so that it would
> > read =2744$K10
> > the several more columns down so it would read =2744$K11, etc.
> >
> > I did not mention the rows below the original line, as I knew I would have
> > to cut and paste larger areas.........
> >
> > In other word, I need to move a formula, referencing the next row down on
> > the other spreadsheet, which is call 2744.
> >
> >
> > "bigwheel" wrote:
> >
> > > Well, if the scenario I described in my last posting is incorrect, then I
> > > guess you'll need to describe it again ...
> > >
> > > "carrera" wrote:
> > >
> > > > so, do you have a solution for my scenerio?
> > > >
> > > > "bigwheel" wrote:
> > > >
> > > > > Sorry, I must have totally misunderstood you. I thought you wanted a formula
> > > > > that took data from consecutive rows in column S of workbook 2744 and put
> > > > > that data into non-adjacent columns in a different workbook but in such a way
> > > > > as to avoid having to type the formula into each location. The solution I
> > > > > was trying to convey was a method of creating the consecutive formula
> > > > > (=2744!$S9, =2744!$S10, =2744!$S11 etc) then cutting and pasting those into
> > > > > the appropriate columns in the other workbook.
> > > > >
> > > > > "carrera" wrote:
> > > > >
> > > > > > unfortunately that will not work because in the cells below the one mentioned
> > > > > > there are more formulas for the next thirty or so lines that read.....
> > > > > > =2744!$U9
> > > > > > =2744!$AC9
> > > > > > =2744!$AG9
> > > > > > et cetera
> > > > > >
> > > > > > my intent is to copy all 30 or so cells in that column and paste into the
> > > > > > other intermittent columns to the right.
> > > > > >
> > > > > > If I'm reading you correctly, this would involve creating blank rows between
> > > > > > each of the formulas above.
> > > > > >
> > > > > > Other suggestions?
> > > > > >
> > > > > > "bigwheel" wrote:
> > > > > >
> > > > > > > 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