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