Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Glad I could help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forumla | Excel Worksheet Functions | |||
test forumla rather than result | Excel Worksheet Functions | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) | |||
Adding to a range in a reference? | New Users to Excel |