Printable View
Hello everyone,
Every month i prepare an exel file which i have to send to many recipents. The File containins sensitive data and i have to divide it into several different parts.
Is there a technical possibility to show the data only of person who oppened the file (by user id)?
Thank you in advance for your help :)
Not sure I understand. What if the person you email the file to forwards the email to Person#3. Person#3 opens the file and would be able to see the data?
Ok, now i see that iwrote this a little bit incomprehensibly J
From the beginning...
Every employee in ourcompany logs into the computer using their ID number.
My task is to make areport that I send to superiors and directors. Now I need to divide the fileinto about 30 separate files so that the data of employees of other superiorsdon’t go to them.
Is there a technical possibilityto send one file to everyone and the particular manager could see only the dataof his employees?
Example below:
Employe Supervisor ID Director ID Number of absence days Last name First name Smith
John
A2212 A0932 4 1 Jones David A2212 A0932 8 Johnson Michael A2212 A0932 10 Lee Chris A2212 A0932 27 Brown Mike A2212 A0932 56 Williams Mark A2212 A0932 29 Rodriguez Paul A2212 A0932 6 Garcia Daniel A2212 A0932 4 Gonzalez James A2212 A0932 4 Lopez Maria A4544 A0932 18 2 Lee Paul A4544 A0932 33 Brown Daniel A4544 A0932 8 Williams James A4544 A0932 4 Smith
Maria A9893 A0045 20 3 Jones Michael A9893 A0045 7 Gonzalez Chris A9893 A0045 22 Lopez Mike A9893 A0045 8 Lee John
A9893 A0045 17 Brown David A9893 A0045 8 Williams Paul A2954 A0045 20 4 Johnson Michael A3376 A0045 23 5 Gonzalez John
A3376 A0045 11
In this case I have todivide the file into 5 parts.
Thanks in advance for your help
Use advancedfilter.
This is possible. But keep in mind, this is NOT what Excel is good at. You can write a macro to hide/unhide sheets based on a person's id. But if a person has VBA skills and Google, they would likely be able to hack it open. My advice.... if you don't want a person to see the data, do not send it to them.
Instead, maybe write a macro that creates 30 different workbooks based on what you want/don't want each person to see??