I have found a way to copy cell values from one sheet to another sheet so I can access PREVIOUS cell values. But using the CHANGE event does not copy the results from formulas. MSDN says there is a Calculate event, but it does not have the range stuff and I'm not sure how to use it.
QUESTION: How can I copy the formula results from a sheet to another location for reference later, AND REMEMBER WHAT THEY WERE AFTER ONE RECALCULATION?
This will then be used with conditional logic: If my new formula result is > than last result, then do something. If not, do something else.
Thanks in advance for any help.