PDA

View Full Version : Excel file open by specific ID number



Stiepanus
08-13-2018, 07:09 AM
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
08-13-2018, 02:12 PM
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
08-14-2018, 01:07 AM
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
08-14-2018, 01:10 AM
Use advancedfilter.

fb7894
08-14-2018, 07:24 AM
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??