I have 2 (two) different payroll sheets with the ONLY potential matching data being the employee name. I can get this to equal each other on the sheets - HOWEVER - Look at my examples and see if there is an easier way than so many checks and attempting to populate:
Example with title and values
Worksheet 1
CC Shift Emp Name L, F Ttl Hrs Reg Hrs OT DT
123987 2 Doe, John 12 6 3 3
Worksheet 2
Lname Fname, Dept Ref # Pay Rate
Doe John DIV6789875634123 NY6590T 10.87
The OTHER similar number is the CC = Dept in that the 123 & 987 are found in BOTH columns (fields).
The FINAL similar numbers through a lookup table would be the SHIFT # = "Pay Rate" -- ie. 2 = 10.87
Is there a way to populate from Worksheet 1 the following fields in Worksheet 2: Reg Hr, OT, DT??
There will be instances through Worksheet 2 where there is nothing equal because employee was not in that department - yet we can not have ERROR coming in because I need to TOTAL each employee.
I can separate out the first & last names using trim function etc but the real questions is the populating from different worksheet over
AND
Each week the worksheets come in with a different date - ie "Payroll Week 061209" and "CC 120906" -- I am thinking that we need to have macros developed and place on a network drive so any employee can pull up the macro...
Thanks in advance for your help - I found the name separation on a different thread.
Example with title and values
Worksheet 1
CC Shift Emp Name L, F Ttl Hrs Reg Hrs OT DT
123987 2 Doe, John 12 6 3 3
Worksheet 2
Lname Fname, Dept Ref # Pay Rate
Doe John DIV6789875634123 NY6590T 10.87
The OTHER similar number is the CC = Dept in that the 123 & 987 are found in BOTH columns (fields).
The FINAL similar numbers through a lookup table would be the SHIFT # = "Pay Rate" -- ie. 2 = 10.87
Is there a way to populate from Worksheet 1 the following fields in Worksheet 2: Reg Hr, OT, DT??
There will be instances through Worksheet 2 where there is nothing equal because employee was not in that department - yet we can not have ERROR coming in because I need to TOTAL each employee.
I can separate out the first & last names using trim function etc but the real questions is the populating from different worksheet over
AND
Each week the worksheets come in with a different date - ie "Payroll Week 061209" and "CC 120906" -- I am thinking that we need to have macros developed and place on a network drive so any employee can pull up the macro...
Thanks in advance for your help - I found the name separation on a different thread.