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

Copper Contributor

Hello, 

 

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.