Excel file open by specific ID number

[Stiepanus]

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

[fb7894]

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?

[Stiepanus]

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

[snb]

Use advancedfilter.

[fb7894]

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??