Order sheet - VBA help

[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!

[harbour1302]

I have attched my sheet if this helps.

https://www.excelforum.com/attachmen...1&d=1497898910