Hello,
I have a spreadsheet which is shared accross a vast amount of users, upon first open of the document Management would populate a sheet to contain staff credentials based on thier System Login Data.
So for instance, i logon to my machine and i have a staff number that is only allocated to me, the environ variable would read and display this, So Management would go into the document and be face with 3 Cells, Cell1 = Ny Name, Cell2 = Staff Number, Cell3 = Team i Belong to.
So when i open the document, the environ variable would check my staff number then access the list to see who i am and where i belong then place me accordingly.
Team1 Would only see sheet 1
Team2 Would only see sheet 2
and so on....
Any Help?
Bookmarks