I'm working on a workbook to help me with payroll, and I'm now trying to fill out some cell values based on a NAME picked out from a drop down list of NAMES. What I need, to help make things faster, is to have excel prefill the work hours based on the WEEK NUMBER and NAME of the employee. The worksheet that needs to be filled after picking the name from the drop down list is named "Time Input", and the source of the data I need pulled from is called "Shifts". Here are pictures of the before and after:
Without Name.jpg After Pick.jpg
I was thinking of somehow tweaking this code I got from a similar problem I had before, but I need some help trying to figure it out, because now I have two criterias I need to match before copying and pasting into the "Time Input" Worksheet, and I also have alot more Areas. I'm thinking I would need to loop through the different groups in the "Shifts" worksheet and look to match the NAME and WEEK NUMBER. I'm new to VBA and I really don't have much clue on how to do this.
Please help!!
Bookmarks