Data Entry and Recall

Hey Guys,

I am really hoping you can help me out. I am fairly new to the VBA aspect of excel and would love to learn more.

I am trying to streamline out Employee Time Sheets. I would like to be able to enter each employees hours on the master sheet and have newly entered data save to the corresponding employee's worksheet.

Example:
If I select "Smith, Tom" from the drop-down on the "Calendar Overview", this sheet will recall the data from "Smith, Tom" hidden worksheet. From there I can enter in his new hours on the corresponding days on the "Calendar Overview" worksheet. Then the newly entered hours will then save to "Smith, Tom" worksheet. Essentially this example would happen for all employees listed in the drop-down on the "Calendar Overview" sheet.

Is this even possible? I have about 30 employees that would have hidden sheets that the "Calendar Overview" worksheet would need to transfer data to.

I have attached a copy of the excel file on which I would love this to work.

Hello,

Please see attached workbook which demonstrates how you achieve this read/write functionality with VBA.

Here are the constraints with this code:

1.) Calendar sheet must not change its name.
2.) Location of criteria name must not change ("C2")
3.) The range i chose to read/write is C5:R58 - adjust as needed in every instance you see this range.
4.) You can add as many employees as you wish. However, the sheet name must be precisely the same as what you have listed in the criteria field. Otherwise, this will not work.
5.) I experienced strange behavior with this workbook - the change event wouldn't fire on multiple accounts, forcing me to restart the workbook. More than likely a fault with my system, but if you experience absolutely 0 code execution from the workbook, there is an issue.

Items 1-4 can, of course, be modified to meet your needs.

Regards,