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
Bookmarks