Dear experts,
I have an excel document that is processing some amount of data and turn it into daily reports. After I make a report I use macro to separate it from the document into a new sheet and save it separately. The problem is those separate reports still remain dependent on the main excel document where they were created. As the data changes in the mother excel file, it updates all the old reports on the computer and basically I loose the old data.
Could you, please, advice on what can I do to stop those files being dependent and just remain with the values that they contained at the moment of creation?
To be more clear, here is the formula that appears in the cells of the reports and make them dependent:
This is the macro that I use to separate reports:
Thank you!
Bookmarks