R
richzip
Hello,
I am thinking about setting up a master worksheet that has each employee on
there, along with the total hours worked for the month. Each employee will
also have his/her own worksheet, where they can enter their hours worked for
each date. The hours on each worksheet will be totaled, and this total will
be carried over to the master worksheet. Each employee should have access to
read/write their individual worksheet, but ONLY to read the master worksheet.
They also should not be able to add additional worksheets to the workbook.
I was thinking about the master worksheet having employee number as the
first column, and total hours as the 2nd column. Then, each individual
worksheet would have the employee number as the worksheet name. Can I set up
VLOOKUP (or antoher function) to do this?
Example: one of the employee nubmers on the master worksheet is 123. The
"total hours" column for employee 123 would be found in cell A1 (for
example), on the worksheet named "123".
Thank you!
I am thinking about setting up a master worksheet that has each employee on
there, along with the total hours worked for the month. Each employee will
also have his/her own worksheet, where they can enter their hours worked for
each date. The hours on each worksheet will be totaled, and this total will
be carried over to the master worksheet. Each employee should have access to
read/write their individual worksheet, but ONLY to read the master worksheet.
They also should not be able to add additional worksheets to the workbook.
I was thinking about the master worksheet having employee number as the
first column, and total hours as the 2nd column. Then, each individual
worksheet would have the employee number as the worksheet name. Can I set up
VLOOKUP (or antoher function) to do this?
Example: one of the employee nubmers on the master worksheet is 123. The
"total hours" column for employee 123 would be found in cell A1 (for
example), on the worksheet named "123".
Thank you!