Copying a formula down a column
I have made a expence jurnal, column c is the account numbers eg, 6000 for
rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
You change it for each row by copying the formula down the column.
The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
If there is data in an adjacent column, then the easiest way is to double
click the fill handle best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Fred Smith" wrote in message ... You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
You lost me there Bernard :
double click in the fill handle? it does not do anything. Maybe this is for XL 2007 I have 2003. "Bernard Liengme" wrote: If there is data in an adjacent column, then the easiest way is to double click the fill handle best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Fred Smith" wrote in message ... You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
It works in 2003 too. It will copy the cell down as far as there is data in
the column to the left. Regards, Fred. "Excelfan" wrote in message ... You lost me there Bernard : double click in the fill handle? it does not do anything. Maybe this is for XL 2007 I have 2003. "Bernard Liengme" wrote: If there is data in an adjacent column, then the easiest way is to double click the fill handle best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Fred Smith" wrote in message ... You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
It sure works!
My bad of course. Thanks. "Fred Smith" wrote: It works in 2003 too. It will copy the cell down as far as there is data in the column to the left. Regards, Fred. "Excelfan" wrote in message ... You lost me there Bernard : double click in the fill handle? it does not do anything. Maybe this is for XL 2007 I have 2003. "Bernard Liengme" wrote: If there is data in an adjacent column, then the easiest way is to double click the fill handle best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Fred Smith" wrote in message ... You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
Thank you Fred it saved me 3 hrs of typing.
"Fred Smith" wrote: You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
Copying a formula down a column
You're welcome. Thanks for feeding back.
Regards, Fred. "Mike Stewart" wrote in message ... Thank you Fred it saved me 3 hrs of typing. "Fred Smith" wrote: You change it for each row by copying the formula down the column. The easiest way to copy the formula is to drag the fill handle. The fill handle is the little black box on the bottom right of the cell. Click and drag it down your column. Excel should adjust your formula as needed. Regards, Fred. "Mike Stewart" wrote in message ... I have made a expence jurnal, column c is the account numbers eg, 6000 for rent 6001 elect. Across the shet I have hedders column D Rent, Column E Elect and so on across. The question I have is, I have to copy into each box under rent =IfC4=6000 then the dollar amount is automaticly put into the d column on the same row. As it is now I have to go throu each row under column d and type the formula due to the fact that it has to state in the function box then save it each time I have figuard out the farmula, I just don't know how to make it change for each row. Example: A B C D E F Date Who Check Acount# Elect Rent 3 X XX 123 6000 500.00 4 5 6 7 8 9 and so on Hope this is enough info. Mike |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com