Hello,
I would like to track the changes in the bottom line totals in excel from the last action whether the last action is the insertion of a new row
or the changing of an existing cell.
So for instance if I insert a copy of a row anywhere in the sheet it will give me the amount the bottom lines have changed from the last bottom lines.
So using the attached file as an example...
If I copied row 7 and inserted it anywhere in the list the amount the bottom lines have changed for Extended list, Budgeted Extended Cost and Total Price will be displayed in the Description header.
Also if I change a value in the list price column the bottom line changes will also update in the description header.
I think the attached file will illustrate what I am trying to achieve.
This might be trivial or this may be impossible in Excel.
Thanks for any help,
Bookmarks