Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically copy formula in column when adding new row....
Hello all. Sorry if I am posting this question in the wrong category, but
this is my first post here. I am using Excel 2007, and I am trying to automatically copy a formula that's in a column when I add a new row. I'll explain a little more in detail what I am hoping to achieve. My spreadsheet is intended to show profit and loss for my sales. Columns A:W all have details specific to the products that I am selling, including original purchase price, sale price, shipping, fees, etc... In Column X, I have this formula " =SUM(Q4:W4)*L4 ", and then in Column Y, I have this formula " =SUM(R4:W4)+(Q4*L4)-(K4*L4) ". Both formulas work with the information I have in this spreadsheet for what I am wanting them to do, but I would like to take it a step further. Each row represents an item that I am selling, and I am selling more products more frequently (thankfully) so I want to automate the calculations in columns X & Y. I do know how to copy a formula by using the CTRL + C and CTRL + V, and the fill function in excel, but I have different colors and fonts for specific items, and I don't like have to repair that once I copy the formula. Is there a way to do what I want? I tried copying the formula starting at X1 and ending at X1000 just to see how that would do, but when I went to print my spreadsheet, it was printing 50 pages of ' $ - ' in the columns b/c there were no figures to calculate the formula. Any help that I can get would be GREAT! I appreciate all the help. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically copy formula in column when adding new row....
Have you tried to Copy a row and then Insert Copied Cells instead of
inserting a blank row? "Jasmine R" wrote: Hello all. Sorry if I am posting this question in the wrong category, but this is my first post here. I am using Excel 2007, and I am trying to automatically copy a formula that's in a column when I add a new row. I'll explain a little more in detail what I am hoping to achieve. My spreadsheet is intended to show profit and loss for my sales. Columns A:W all have details specific to the products that I am selling, including original purchase price, sale price, shipping, fees, etc... In Column X, I have this formula " =SUM(Q4:W4)*L4 ", and then in Column Y, I have this formula " =SUM(R4:W4)+(Q4*L4)-(K4*L4) ". Both formulas work with the information I have in this spreadsheet for what I am wanting them to do, but I would like to take it a step further. Each row represents an item that I am selling, and I am selling more products more frequently (thankfully) so I want to automate the calculations in columns X & Y. I do know how to copy a formula by using the CTRL + C and CTRL + V, and the fill function in excel, but I have different colors and fonts for specific items, and I don't like have to repair that once I copy the formula. Is there a way to do what I want? I tried copying the formula starting at X1 and ending at X1000 just to see how that would do, but when I went to print my spreadsheet, it was printing 50 pages of ' $ - ' in the columns b/c there were no figures to calculate the formula. Any help that I can get would be GREAT! I appreciate all the help. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically copy formula in column when adding new row....
Hi, thanks for the reply. Yes, unfortunately, I have tried. I read a post
that recommended adding *** to the last row of your document, then just to insert all rows thereafter before that row....but it didn't work. BUT I have good news....I figured it out. Simple enough as it turns out. All I had to do was hold down the CTRL button when I do my first auto fill. For example, I had rows 3-78 filled with information. My first formula was in Column X, row 3, so once I verified that formula, I just held down the CTRL button while doing the auto fill to row 78, and then when I entered information into row 79.....IT WORKED! I remembered the CTRL being some type of copy function but I didn't know it would work with this until I tried it. Thanks again for the help, but this one has been solved. THANKS! "Nadine" wrote: Have you tried to Copy a row and then Insert Copied Cells instead of inserting a blank row? "Jasmine R" wrote: Hello all. Sorry if I am posting this question in the wrong category, but this is my first post here. I am using Excel 2007, and I am trying to automatically copy a formula that's in a column when I add a new row. I'll explain a little more in detail what I am hoping to achieve. My spreadsheet is intended to show profit and loss for my sales. Columns A:W all have details specific to the products that I am selling, including original purchase price, sale price, shipping, fees, etc... In Column X, I have this formula " =SUM(Q4:W4)*L4 ", and then in Column Y, I have this formula " =SUM(R4:W4)+(Q4*L4)-(K4*L4) ". Both formulas work with the information I have in this spreadsheet for what I am wanting them to do, but I would like to take it a step further. Each row represents an item that I am selling, and I am selling more products more frequently (thankfully) so I want to automate the calculations in columns X & Y. I do know how to copy a formula by using the CTRL + C and CTRL + V, and the fill function in excel, but I have different colors and fonts for specific items, and I don't like have to repair that once I copy the formula. Is there a way to do what I want? I tried copying the formula starting at X1 and ending at X1000 just to see how that would do, but when I went to print my spreadsheet, it was printing 50 pages of ' $ - ' in the columns b/c there were no figures to calculate the formula. Any help that I can get would be GREAT! I appreciate all the help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically adding formula to added cells | Excel Discussion (Misc queries) | |||
Copy formula with row automatically modified not column | Excel Worksheet Functions | |||
Adding a column and recalculate formula automatically | Excel Discussion (Misc queries) | |||
How to automatically copy VLOOKUP FORMULA IN A COLUMN | Excel Discussion (Misc queries) | |||
Automatically insert row and copy formula | Excel Worksheet Functions |