T
thomas404
I have a spreadsheet that uses VLOOKUP to get a person's pay rate based on
their name and use it to calculate a running total of our YTD overtime
expense in my main sheet. The problem I have is when they get a raise, I want
to use the new rate for all new calculations, but I don't want to change the
previous calculations. Can you give me some ideas to explore?
example....
day name $/hour hours OT pay YTD OT expense
9/10 Bill 10 2 20.00 20.00 (Bill's rate is 10.00
in the lookup table)
9/11 Jane 12 3 36.00 56.00
9/15 Bill 11 2 22.00 78.00 (Bill has a new rate
of $11/hr, but I don't want my table to go back and change the entry for 9/10.
their name and use it to calculate a running total of our YTD overtime
expense in my main sheet. The problem I have is when they get a raise, I want
to use the new rate for all new calculations, but I don't want to change the
previous calculations. Can you give me some ideas to explore?
example....
day name $/hour hours OT pay YTD OT expense
9/10 Bill 10 2 20.00 20.00 (Bill's rate is 10.00
in the lookup table)
9/11 Jane 12 3 36.00 56.00
9/15 Bill 11 2 22.00 78.00 (Bill has a new rate
of $11/hr, but I don't want my table to go back and change the entry for 9/10.