can someone please let me know the code for below requirement
In sheet1 cell A1 I will enter todays date using formula =today() and in B1 a value, A1 and B1 change daily because of day change ; on same sheet on column C are dates(every day of the current month) and column B is empty. I would like a macro to search on column C for today's date C and copy the value from B1 to column D next to the today's date.
Please find attached xlsm file which has the requirement
Please help
In sheet1 cell A1 I will enter todays date using formula =today() and in B1 a value, A1 and B1 change daily because of day change ; on same sheet on column C are dates(every day of the current month) and column B is empty. I would like a macro to search on column C for today's date C and copy the value from B1 to column D next to the today's date.
Please find attached xlsm file which has the requirement
Please help