I have several worksheets within a file. Each of the respective worksheets (minus one - the "master", described below . . . please overlook the politically incorrect use of that terminology; I didn't select it) is a monthly summary of hours worked on individual calendar days by several individual employees. Each employee's time is grouped together in rows (see the screenshot below for an example. It stops at Row 19 in the screenshot below, but goes on for hundreds of rows in the real file).
On the "master" worksheet (the first worksheet in the file, named "Rates") are a list of names, their respective work positions, and the hourly rate for their respective positions (see the screenshot below).
The list of names and rates goes on for several hundred rows too.
What I need to do is look up names on the "master" and fill in their specific rates on each of the monthly worksheets (i.e., Column D's in the above screenshot). In the above example, Cell D2 would show $65 an hour, Cell D8 would show $70 an hour, etc., as listed on the "master" by association with the individual person.
I think this is a VLOOKUP candidate. I'm thinking I'd put a VLOOKUP formula in Cell D2, search for the individual name on the "master" to find a person's rate and then display it. Then (hopefully) by copying the formula in D2 downward for the several hundred rows in each monthly worksheet I could then show very person's rate from the master.
I've tried to figure this out on my own but I'm stumped. Any help would be very much appreciated.
On the "master" worksheet (the first worksheet in the file, named "Rates") are a list of names, their respective work positions, and the hourly rate for their respective positions (see the screenshot below).
The list of names and rates goes on for several hundred rows too.
What I need to do is look up names on the "master" and fill in their specific rates on each of the monthly worksheets (i.e., Column D's in the above screenshot). In the above example, Cell D2 would show $65 an hour, Cell D8 would show $70 an hour, etc., as listed on the "master" by association with the individual person.
I think this is a VLOOKUP candidate. I'm thinking I'd put a VLOOKUP formula in Cell D2, search for the individual name on the "master" to find a person's rate and then display it. Then (hopefully) by copying the formula in D2 downward for the several hundred rows in each monthly worksheet I could then show very person's rate from the master.
I've tried to figure this out on my own but I'm stumped. Any help would be very much appreciated.
