Copy Data from one sheet to another from same number of cell which keep updating every day

[SKN2022]

Hello
I want to copy data from one sheet to another but the problem is that the source data is keep updating on same number of cells daily basis, so to extract data from those cells and freeze those data to another sheet, so that it will not update next day due to change in source data.
for example
in sheet 1 data from cell E3 to E7 is keep updating on daily basis (date wise like 24.08.22), now i want to copy this data automatically to sheet 2 for same date(24.08.22), now next day(25.08.22) the cell data of E3 to E7 in sheet 1 is changed so now i want these data to be copied to sheet 2 for date (25.08.22), but the data of 24.08.22 in sheet 2 not to be changed as its source data E3 to E7 is changed on 25.08.22, rather 24.08.22 data in sheet 2 should freeze.

hope u understood the problem.

thanks

 

[Joe4]

There are a bunch of tutorials and videos on-line that you can find with a simple Google Search. So I would just recommend doing that, and seeing which one looks most promising to you.
There are also various tutorial books on VBA coding, including a bunch from the MrExcel store.

 

[SKN2022]

ok thanks for the suggestions