Should I copy text, use formulas or write VBA Code

Hi,

I'm currently working on a workbook that will use everything I'm able to do in excel. VBA, Buttons, Listfields, Formulas and so on. I'm currently thinking of making a copy of a certain table so in a few weeks I can see what the table looked back then and compare it with the new one. Potential doing those images every week I'm gonna have a lot of "copies" of my table. The Range will be around "A1:A500" and a huge amount of it are formulas.

So my question is which is the best method to "save" those images of the table. Should I copy it with the formulas or just the text. Or maybe the formulas and switch the different images only for the "data" of the table and when I say "show me what the table looked like 5 weeks ago" vba puts the data in and the whole table gets recalculated.


In short:
Which method is most efficient in term of working speed for excel

1. copy from database and formulas recalculate
2. copy whole table as text

Thank you. Was unsure and wanted to be sure because once implemented it will be a hassle to change everything