sepaltoona
New Member
- Joined
- Aug 30, 2014
- Messages
- 7
I have made a fairly elaborate finance spreadsheet on Sheet1 to track long term financial projections (tracking monthly bills over a year in the future). It contains currency values for known/expected bills and has many formulas. Paid bills in Sheet1 are in regular font, while future bills are in italics (so I know what has been paid vs. what hasn't). Sheet2 mirrors Sheet1, but only shows what bills are already paid up to now (manually updated to reflect current bank account values only after a bill has been paid and clears the bank). At present, when a bill has been paid I remove the italics from the value of a cell in Sheet1 (to mark it as paid), and then just copy it into the same cell on Sheet2. This is annoying to manually add the value from Sheet 1 (after removing the italics) to Sheet2 every time a bill gets paid.
I'm sure there is a way to automatically have the contents (a currency value) of a range of cells in Sheet1 added to the same range of cells in Sheet2, but only for the Sheet1 values that are italicized.
Hopefully someone here has an idea!
Thanks!
I'm sure there is a way to automatically have the contents (a currency value) of a range of cells in Sheet1 added to the same range of cells in Sheet2, but only for the Sheet1 values that are italicized.
Hopefully someone here has an idea!
Thanks!