Copy /Paste column on specific time using excel script

I need to copy specific column A:A on daily basis at exact time like at 5:00 PM, the data keeps updating so it will be something like snapshot of today work, and next day same thing but to past it in column B:B and soo on,
Pic 1.JPG