I have a spreadsheet that records payroll. Within the file there are 52 worksheets (one per week for the entire year).
Every worksheet is formatted identically. I would like to add a 53rd tab that totals all of the entries in the weekly sheets. I want to use VLOOKUP because there is no guarantee that new employees will not be added or existing ones removed during the year.
Is there anyway to do a global VLOOKUP throughout the sheet or do I have to add a formula that adds each individually such as:
=VLOOKUP(B5,'01.06.09'!B3:K40,6,FALSE)+=VLOOKUP(B5,'01.13.09'!B3:K40,6,FALSE)+ ...
THANKS
Every worksheet is formatted identically. I would like to add a 53rd tab that totals all of the entries in the weekly sheets. I want to use VLOOKUP because there is no guarantee that new employees will not be added or existing ones removed during the year.
Is there anyway to do a global VLOOKUP throughout the sheet or do I have to add a formula that adds each individually such as:
=VLOOKUP(B5,'01.06.09'!B3:K40,6,FALSE)+=VLOOKUP(B5,'01.13.09'!B3:K40,6,FALSE)+ ...
THANKS