Hi, I am working with a spreadsheet that shows a summary of sales targets and actuals by quarter. There is a "working area" where the sales team is allowed to input their targets each month. The total at the bottom of this working area is referenced by Cell ID in the summary tables.
At the end of each quarter, I want to be able to "freeze" the value in the summary target cell for that quarter at whatever the actual number value is, then have the target number by cell reference now show up in the next quarter's target cell. Right now this is all done manually - is there a way to do this with a formula? I know how to use IF and AND to figure out which quarter is active and should show the referenced target value, and I even know how to check for the end of the quarter date, but I can't figure out how to dynamically convert that reference to a number value and lock it down so no further changes happen to that cell. Is that even possible?
All suggestions are appreciated!
Cindy
Bookmarks