A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

adding row to forumla



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2005, 05:25 PM
carrera
external usenet poster
 
Posts: n/a
Default adding row to forumla

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
  #2  
Old August 19th, 2005, 07:33 PM
bigwheel
external usenet poster
 
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

  #3  
Old August 19th, 2005, 08:41 PM
carrera
external usenet poster
 
Posts: n/a
Default

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

  #4  
Old August 19th, 2005, 11:52 PM
bigwheel
external usenet poster
 
Posts: n/a
Default

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

  #5  
Old August 20th, 2005, 04:10 PM
carrera
external usenet poster
 
Posts: n/a
Default

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

  #6  
Old August 21st, 2005, 05:44 PM
bigwheel
external usenet poster
 
Posts: n/a
Default

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

  #7  
Old August 22nd, 2005, 04:10 PM
carrera
external usenet poster
 
Posts: n/a
Default

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

  #8  
Old August 23rd, 2005, 02:52 AM
bigwheel
external usenet poster
 
Posts: n/a
Default

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 SpecialTranspose 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

  #9  
Old August 23rd, 2005, 09:55 PM
carrera
external usenet poster
 
Posts: n/a
Default

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 SpecialTranspose 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

  #10  
Old August 23rd, 2005, 10:24 PM
bigwheel
external usenet poster
 
Posts: n/a
Default

Glad I could help
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding months to a given date Alynn Baker Running & Setting Up Queries 2 March 18th, 2005 08:42 PM
Adding up Percentage calculated series of numbers???? LD Using Forms 3 January 8th, 2005 09:32 PM
Insert fillin without adding characters to underline vikesanimal General Discussion 1 September 3rd, 2004 03:32 PM
adding x lines of text, then adding new slide, etc Silvester Powerpoint 2 July 15th, 2004 04:02 PM
Adding auto-numbered field screws up Table order Carl Database Design 5 May 30th, 2004 03:25 AM


All times are GMT +1. The time now is 03:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.