Hi,
I am struggling to figure this query out and hope you can help me!
I have a numeric figure that changes frequently. I need to be able to set something
in place that will do the following:
On workbook 1 a figure is input manually.
This needs to be recorded (snapshot taken) on a certain date I..e the first of the month. The figure captured is automatically put in a cell on workbook 2.
This will run on each month and populate the related cells on workbook 2 with the figure from workbook 1 on the date it's needed.
This figure will be locked in workbook 2 and not change again despite the figure in workbook 1 being amended.
I hope this makes sense it's been so difficult to try and find an answer. I'm new to this depth of excel.
Kind regards,
Drew
I am struggling to figure this query out and hope you can help me!
I have a numeric figure that changes frequently. I need to be able to set something
in place that will do the following:
On workbook 1 a figure is input manually.
This needs to be recorded (snapshot taken) on a certain date I..e the first of the month. The figure captured is automatically put in a cell on workbook 2.
This will run on each month and populate the related cells on workbook 2 with the figure from workbook 1 on the date it's needed.
This figure will be locked in workbook 2 and not change again despite the figure in workbook 1 being amended.
I hope this makes sense it's been so difficult to try and find an answer. I'm new to this depth of excel.
Kind regards,
Drew