Forum Discussion
DHark5454
Apr 20, 2023Copper Contributor
HELP! Is it possible to copy data from one cell to another cell when today = certain date/month?
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...
Akah-Mandela
Apr 20, 2023MCT
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.