|I have a workbook that monitors year to date sales.|
I have to submit a monthly report to our head office, I have created a seperate workbook for this purpose, and have created formulas linking to the original year to date workbook.
My question is, can I set the cells to stop updating? i.e. year to date sales links into my September page, can I set the September workbook to freeze the figure on 30th September rather than keep updating with my year to date workbook?
Thanks in advance for any suggestions!