I am trying to automatically copy the percentage in a cell to a cell on a different worksheet on the 1st day of every month to track the progress of a task.
For example I update cell a1 each week and the percentage increases but on the 1st of each month I would like this percentage to automatically copy into a cell on a different sheet.
Hope this makes sense.
Is this possible.
Any help much appreciated.
By: Steven Sexton