Hi All,

Haven't been able to find a solution to this problem anywhere as of yet. Basically, I have a form on "sheet 1" which is cleared and new figures input each week. I was wondering whether it is possible to transfer this data into a separate table in another sheet (automatically, without copying and pasting) so that I can build an archive of data. The data would need to be copied to a separate table each week in "sheet 2" without overwriting the previous week's data.

Any help with this would be greatly appreciated.

Cheers