Hi All,

In a table I have a particular cell, which contains a number (percentage) calculated from the other data in the table.

The figure will change as the master sheet is updated as and when, however on the 1st of each month id like to take this number and copy it into a separate table to so we can trend it on a graph, for example - Jan 15%, Feb 14%, March 12%

This is first time using VBA which I'm assuming is the method I need to use to achieve this. Could anyone give me a basic overview on how to do this please?

Thanks