Macro/VBA to populate information based on date selected from data validation list

Hi All,

I have a workbook created to help a colleague track time spent on various parts of a business for tax purposes. There is a data validation dropdown list composed of a full calendar year of dates. Below that, the user is allowed type in a description of the activity for whatever business entity they performed it for and next to that, they type in the total hours.

What I am looking for is for a macro or code that will, when they change dates, save information for the date they just typed in and clear the form for the next date. From there, if the user wants to select a date, say, two weeks in the past, the worksheet will automatically populate those cells with the same information they entered from that date in the past. Is this possible?

I've attached a workbook that gives the general idea. I realize that I could create a sortable lookup table in a different sheet, create dynamic ranges, and then sheet 1 to just automatically pull right from that sheet but I was hoping there might be a way to use VBA to do what I'm asking.

Thanks much in advance!

see attached is that the solution you was looking for?
click save data to save new entry into sheet2 and enter a date in cell B5 click lookup to get all the saved entries for that date

Originally Posted by Abhi1687

see attached is that the solution you was looking for?
click save data to save new entry into sheet2 and enter a date in cell B5 click lookup to get all the saved entries for that date

I think this should do it! I will test it once more in the morning and change this to solved. Thank you for your help!!