Entering in employee hours. The 'Work Classification' file has the rates for each work classification.
Need a formula so that when I type in their work classification in 'Hours' file, it autofills the info.
pt.2 - I have a year's worth of payroll to do so should I use a macro to apply this to each sheet in 'Hours' if I make a new sheet for each work week?
See attached.
Thanks!!
With both files open:
Formula:
Please Login or Register to view this content.
Note that you have classification AO in the hours file but it should be A0.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks