R
richzip
I am building a workbook that has one "master" worksheet. This shows total
hours for various employees, and the first column will be their employee
number.
I will then have individual worksheets for each employee. The worksheet
name will be their employee number, and each person goes into his/her own
sheet to update their hours worked by each day, which will then be totaled
for the entire month.
I want the main worksheet to lookup the total hours for each employee, based
on what is on their individual worksheet. Can I set up VLOOKUP (or another
function) to accomplish this? The sheet name used in the VLOOKUP formula
would have to be each persons' employee number.
Thank you
hours for various employees, and the first column will be their employee
number.
I will then have individual worksheets for each employee. The worksheet
name will be their employee number, and each person goes into his/her own
sheet to update their hours worked by each day, which will then be totaled
for the entire month.
I want the main worksheet to lookup the total hours for each employee, based
on what is on their individual worksheet. Can I set up VLOOKUP (or another
function) to accomplish this? The sheet name used in the VLOOKUP formula
would have to be each persons' employee number.
Thank you