First time posting here, i can normally find what i need on google but have not been able to find anything.
I have attached my workbook.
It is a order calculatir in cells F4:I4 i input a sales forecast and this automatically generates an order based on usage from another sheet.
The issue im facing is if i have to adjust this forecast during the week i need to see the changes.
I have added a duplicate sheet minus the formulas, i would like to store the old values of all cells including those that are based on formula results in the sheet called old values. i will then use a third sheet to contain the differnce in values and assign a macro to print.
essentially i just need the VBA code to store all old values, i have played about and managed to save the changes i physically make but not the chnages as a result of a formula recalcualtion.
I'm hoping one of you geniuses can help