Daily saving and exporting of data

Hey guys, bit of a vague keyword title without making it too long so I'll expand here...

I have a spreadsheet that has 9 fields of data that I wish to record every day as they change every day. I like to keep a record of the figures every day so I would be happy for it to export to Access, a sheet in this workbook or another workbook entirely, whichever would be easiest. The figures that I would like to record every day run off formulas from elsewhere in the workbook so I currently have them using the formula "=INT(CLEAN('Home Page'!B10))" in the example workbook attached.

I am trying to make a macro that adds all of the figures into the relevant fields in the row below the previous one using today's date as a reference (please see attached workbook for example). Would this be possible?

Thankyou very much guys, you've been extremely helpful since I joined. I hope to be giving back when I hone my skills.

DataSave.xlsx

Yes that's exactly what I'm looking to do ideally I would like the date to be automatically inserted aswell as each figure into the relevant box if possible.

Interesting, I tried a recorded macro but it didn't seem to work for me. I will adapt to the full sheet I have and let you know how I get on. Thankyou

I've tried it but due to the fact that in my real workbook the figures include formulae it doesn't transfer it. Is there any way to include the formula

Please Login or Register  to view this content.

into each cell that it copies? As I'm getting the same error as when you run this macro with the figures I've updated. Regards.

DataSave.xlsm

Works a treat took very little adapting. Thankyou very much. Rep added.