Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to subtract cells if...
I need to write a macro that will search for the row that includes the word
"Guaranteed" and enter the value of the cell in column N of that row into the cell in column N of the row just below the last row (the total row). Then, subtract that value from the total (the row just above). For example... column A includes a fund name in each row. Column B includes values of these funds in each row. Some spreadsheets will have the fund Guaranteed and some won't. If they do, I will need to subtract the value of Guaranteed from the total of the funds. The last row has the total of the funds in column B. The row directly below the total should show the value of the Guaranteed fund and the following row would show the difference between the total and the Guaranteed. Can anyone help with this? -- Thank you, Jodie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to add or subtract a range of cells | Excel Discussion (Misc queries) | |||
How can I subtract cells in a row | New Users to Excel | |||
How do i subtract cells in an IF function? | Excel Worksheet Functions | |||
Macro to subtract data from cells | Excel Programming | |||
how to add or subtract from two cells into one | Excel Worksheet Functions |