Recording cell value and adding to a list

[Desertbird]

Hello,
I was wondering if I could get some help with this. Below is a single row table with data that changes over time, some values update at different rates. Is there a way to get a daily snapshot of this table on a different sheet, with each new day adding a new row with the values for that day? Ultimately, I want a sheet within the workbook that tracks the daily values so that they can be compared day over day.

Any help with this would be appreciated!

 

[Sahak]

Hi Desertbird,
Maybe this is it?
Before running the code, please rename sheets, data sheet's name "Table" and be stored snapshots sheet's name "Snapshots"

Sub Copy_Snapshot()
    Sheets("Table").Select
    Range("A2:H2").CopyPicture Appearance:=xlScreen, Format:=xlPicture
    Sheets("Snapshots").Select
    Range("A65000").End(xlUp).Offset(1).Value = Int(Now())
    Range("A65000").End(xlUp).Offset(0, 1).Select
    ActiveSheet.Paste
    Range("A65000").End(xlUp).Select
    ActiveWorkbook.Save
End Sub