I want to be able to enter a value into excel on todays date and then by entering that value, it automatically goes to another sheet, searches from a list of dates and then pastes the value at that date



So, this allows me to input the value each day and then it automatically goes into the right spot

Sheet 1

=today() Value

Sheet 2

Date
Today Value
date


I dont do VBA, but cannot figure out how to use formulas in excel that lock after they are updated.


Thanks

Byron