Find date/day across columns and update selective cell below

[emina002]

Hi everyone,hope you all ok.

I just need to find and update specific column only. For example on my uploaded workbook, I have 2 sheet which is "Database" and "Front Cover", the logic is user will only see front cover sheet, once the user already input time in and time out and click the button submit. It will automatically find the date on Database tab(I used Now() formula on B1 cell with format dd-mmm). After the macro/vba code found the specific value like Feb 15 found on AX column it will update the row 4,5,6 of column AX or which could be easy to perform copy paste B4 to B6 of Front cover sheet and copied it to database sheet of Column AX row 4 to 6.


Date is not fix, the admin user of the tool will change the date every quarter. I hope you can give me some hint on how can I start. Thank you in advance

[skywriter]

Here you go. Make sure macros are enabled and then you can push the submit button and see the results on the database sheet.
Now() is not a good choice for cell B1, I changed it to Today().

Good Luck!!!

[emina002]

Hi @skywriter, your solution work. Thanks to you

[skywriter]

Hi @skywriter, your solution work. Thanks to you

My pleasure, thanks for the feedback and the reputation points.