Thank you Arvi. I got your idea and I think I can do the hide sheets. Instead of VLookup formula, I think Pivot is more flexible.


The tricky thing for me is the users log in and passwords because I have a very limited knowledge on programming. I will google search and hope to find possible solutions.

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!

Attached Files

PayrollTest.xlsm (16.5 KB, 6 views)

Thank you Arvi. You really go the extra mile in sharing your ideas and expertise. I will edit our actual payroll then attach it in this same thread.