Dupliate with value changes

[harbour1302]

Hey Guys,

This one has been allusive I am hoping one of the geniuses here can help.

I have an order calculator I developed for my business, I place all my orders Monday for the week, I am having an issue where if I should change my forecasted ales during the week the value of the amount ordered changes.

I would like a vba code to notice when a value has changed since last save and copy the entire sheet to a new workbook with the difference in values.

For example, if I originally needed to order 5 apples and the sales change I now need to order 7 apples; I would like a sheet to open with 2, in the apples row to show the difference I need to order. or -2 if I now require only 3 apples etc.

Is this even possible?

or does anyone have an alternative that would work, I have tried track changes but it doesn't work as all cells contain a formula.

Thanks so much!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...ghlight-cell-when-formula-result-changes.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.