HELP! Is it possible to copy data from one cell to another cell when today = certain date/month?

Copper Contributor



I am looking for a solution to automate the retrieval of data from a cell at a certain point in time. I would like the value in the cell to be copied and permanently pasted to a different sheet when dates change. I have added pictures and highlighted the cells I am looking to use. Please Thank you in advance for any feedback. 



Thank you,


DevonScreenshot 2023-04-20 at 6.02.31 PM.pngScreenshot 2023-04-20 at 6.01.05 PM.png

1 Reply
Try using VLOOKUP like this =VLOOKUP(TODAY(),A2:B12,2) This formula will look in column A from cell 2-12 for today’s date and get the value from column B in the same row.