Quote:
Originally Posted by Marcia
Instead of VLookup formula, I think Pivot is more flexible
|
In attachment it is done with VLOOKUP. I think it is impossible to get it more flexible - the only variable in VLOOKUP formula is the number of column the value is returned from payroll table. In payroll table, you can have any number of columns, and have any headers you want for them.
I dropped all hiding and protecting stuff currently - I think you can do this part yourself, after you design both sheets properly.
The payroll table is an traditional one - when a defined Table is used instead, then there will be no way to make for users reading payroll of other employees impossible, because the Name of Table will be visible in Name Manager window!