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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy a formula to the right increasing the rows from another works
I posted this question this morning, but I did not get a resolve.
Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill -- Tracy |
#2
|
|||
|
|||
Copy a formula to the right increasing the rows from another works
Hi Tracy,
In G7, try: =OFFSET($E$817,COLUMN()-7,) then copy across as far as needed. -- Cheers macropod [MVP - Microsoft Word] "Tracy" wrote in message ... I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill -- Tracy |
#3
|
|||
|
|||
Copy a formula to the right increasing the rows from anotherworks
Tracy,
please put this formula in G7 of the Div 6 sheet: =INDIRECT("'CallList'!E"&(816+COLUMN(A1))) then copy it across the row. You will get: bob ted bill etc as required. Hope this helps. Pete On Aug 26, 10:32*pm, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. *I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. *I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. *So I am filling/copying a formula to the right from a worksheet that has the information going down. *Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet * * * * Div 6 Worksheet * * * * *E * * * * * * * * * * * * * * G * * * * * * * * * * * H * * * * *I 817 * bob * * * * * * * * * * 7 *bob (from E817) *E818 * *E819 818 * ted 819 * bill -- Tracy |
#4
|
|||
|
|||
Copy a formula to the right increasing the rows from another works
Tracy
Same answers as you got to your earlier posting. Please stick with one thread until you get satisfaction. Several of the formulas already given will do what you want. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 14:32:01 -0700, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill |
#5
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
Pete,
Thank you, thank you, thank you. Hours of work, gone in a flash of a formula. Bloody Nora you made it seem easy. Many thanks. Cheers!! -- Tracy "Pete_UK" wrote: Tracy, please put this formula in G7 of the Div 6 sheet: =INDIRECT("'CallList'!E"&(816+COLUMN(A1))) then copy it across the row. You will get: bob ted bill etc as required. Hope this helps. Pete On Aug 26, 10:32 pm, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill -- Tracy |
#6
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
Pete, one more question if I can be so bold to ask.
Can you take this formula and make it able to copy across like the other formula increaseing the cell 817 to 818, 819, etc..? =IF('Call List'!$B$817=1,'Call List'!$D$817,"Not in Use") -- Tracy "Pete_UK" wrote: Tracy, please put this formula in G7 of the Div 6 sheet: =INDIRECT("'CallList'!E"&(816+COLUMN(A1))) then copy it across the row. You will get: bob ted bill etc as required. Hope this helps. Pete On Aug 26, 10:32 pm, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill -- Tracy |
#7
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
You're welcome, Tracy - I'm glad you gave it a go.
Pete On Aug 27, 2:48*pm, Tracy wrote: Pete, Thank you, thank you, thank you. Hours of work, gone in a flash of a formula. Bloody Nora you made it seem easy. Many thanks. Cheers!! -- Tracy |
#8
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
Try this, then, Tracy:
=IF(INDIRECT("'Call List'!B"&(816+COLUMN(A1)))=1,INDIRECT("'Call List'! D"&(816+COLUMN(A1))),"Not in Use") The $ symbols are not required here as the references to B and D will not change as they are text values. Just copy this across as required. Hope this helps. Pete On Aug 27, 2:50*pm, Tracy wrote: Pete, one more question if I can be so bold to ask. Can you take this formula and make it able to copy across like the other formula increaseing the cell 817 to 818, 819, etc..? =IF('Call List'!$B$817=1,'Call List'!$D$817,"Not in Use") -- Tracy "Pete_UK" wrote: Tracy, please put this formula in G7 of the Div 6 sheet: =INDIRECT("'CallList'!E"&(816+COLUMN(A1))) then copy it across the row. You will get: bob * * *ted * * *bill * * *etc as required. Hope this helps. Pete On Aug 26, 10:32 pm, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. *I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. *I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. *So I am filling/copying a formula to the right from a worksheet that has the information going down. *Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet * * * * Div 6 Worksheet * * * * *E * * * * * * * * * * * * * * G * * * * * * * * * * * H * * * * *I 817 * bob * * * * * * * * * * 7 *bob (from E817) *E818 * *E819 818 * ted 819 * bill -- Tracy- Hide quoted text - - Show quoted text - |
#9
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
Once again Thank you Pete for all your help.
-- Tracy "Pete_UK" wrote: Try this, then, Tracy: =IF(INDIRECT("'Call List'!B"&(816+COLUMN(A1)))=1,INDIRECT("'Call List'! D"&(816+COLUMN(A1))),"Not in Use") The $ symbols are not required here as the references to B and D will not change as they are text values. Just copy this across as required. Hope this helps. Pete On Aug 27, 2:50 pm, Tracy wrote: Pete, one more question if I can be so bold to ask. Can you take this formula and make it able to copy across like the other formula increaseing the cell 817 to 818, 819, etc..? =IF('Call List'!$B$817=1,'Call List'!$D$817,"Not in Use") -- Tracy "Pete_UK" wrote: Tracy, please put this formula in G7 of the Div 6 sheet: =INDIRECT("'CallList'!E"&(816+COLUMN(A1))) then copy it across the row. You will get: bob ted bill etc as required. Hope this helps. Pete On Aug 26, 10:32 pm, Tracy wrote: I posted this question this morning, but I did not get a resolve. Maybe this is a little more clear. I have two worksheets within my file Worksheet called "Call List" and another called "Div 6" Within the Div 6 worksheet I have a formula in cell (G7) which copies information I already input from cell E817 from the Call List wksht. I now want to fill and/or copy that formula in Div 6 G7 to all the cells adjacent to the right while increaseing the formula from the Call List worksheet by one row. So I am filling/copying a formula to the right from a worksheet that has the information going down. Everytime I try to copy the formula the column keeps increasing instead of the row, i.e E817, G817 when I want the formula to read E817, E818, E819, ect. Call List Worksheet Div 6 Worksheet E G H I 817 bob 7 bob (from E817) E818 E819 818 ted 819 bill -- Tracy- Hide quoted text - - Show quoted text - |
#10
|
|||
|
|||
Copy a formula to the right increasing the rows from another w
That's okay - thanks for feeding back.
Pete On Aug 27, 4:45*pm, Tracy wrote: Once again Thank you Pete for all your help. -- Tracy |
Thread Tools | |
Display Modes | |
|
|