Forum Discussion

DHark5454's avatar
DHark5454
Copper Contributor
Apr 20, 2023

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 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,

 

Devon

Excel
Formulas and Functions
Macros and VBA
  • Akah-Mandela's avatar
    Akah-Mandela
    Brass Contributor
    Apr 20, 2023
    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.

Resources