Forum Discussion
Formula Help
I have a workbook that produces 2 percentages when data is feed into it from another workbook. In this workbook I type in a specific cell the name of the workbook which includes a date. When I open t...
It appears the Monday report makes calculations but those calculation will change based on the date/file you are using. And now you want to 'capture' the calculation into your calendar file on the date it was done/referencing. The problem is that worksheet function always update based on the current data and will not 'save' the prior data. So you open the files for Monday Jan 2 and it could in theory fill in Monday Jan 2 and then you open files for Mon Jan 9 and it could fill in Jan 9 but the data in Jan 2 will go away. Basically you need to just copy and paste the values to make them permanent. Alternatively you could have a macro do that step for you but seems a bit much for a simple copy paste (you could/should make it easier by adding a formula in the Monday Report that creates the cell text exactly the way you want to paste it into the calendar)