Excel 2016 help pls?

[blue-eye-boy]

Hey there,

I'm busy with a report for dept of Labour, regarding employment equity. I have a long list of employees with all their details in one workbook, but I need to make a new workbook, and work with the data in workbook 1. I will have to create tabs for example (African male, African Female, White male, etc etc.) This way the data in workbook 1 gets sorted in workbook 2 individual tabs. But I want this to be automatically added to workbook2 whenever I add or change employee details in workbook 1.

Is this possible, and can someone pls guide me a bit in the right direction? Even a tip on what to google, as I cant find the right solution or description for what I need in google.

Thanks a million

 

[Cray]

Hey there,

I'm busy with a report for dept of Labour, regarding employment equity. I have a long list of employees with all their details in one workbook, but I need to make a new workbook, and work with the data in workbook 1. I will have to create tabs for example (African male, African Female, White male, etc etc.) This way the data in workbook 1 gets sorted in workbook 2 individual tabs. But I want this to be automatically added to workbook2 whenever I add or change employee details in workbook 1.

Is this possible, and can someone pls guide me a bit in the right direction? Even a tip on what to google, as I cant find the right solution or description for what I need in google.

Thanks a million

This article mentions a similar requirement...

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2007/automatically-create-subset-of-records-on/33a4eedd-f6a7-4dab-b104-b767cb5ee776?auth=1

 

[envo]

Also, you're in contravention of the POPI act and would need to stop before the act goes "live" (which is soon or has already started)

 

[Cray]

Also, you're in contravention of the POPI act and would need to stop before the act goes "live" (which is soon or has already started)

Good point, any personal information in the report would have to be sanitized of information that can be used to identify any specific individual (ID numbers etc...)

 

[blue-eye-boy]

I understand the identity issue, the report I do for them wont contain any personal info, only names, then racial, gender, salaries, things like that. Dept of Labour requires this from me for employment equity.

 

[Corelli]

POPI is already Active and so is PPI

But then again Era steer didn't seem to mind when they leaked the entire South Africa Home Affairs information, with more that they have been collecting.

Best is you do this in access or else you will have to create proper pivot tables reading from one another. It's tricky. But due to the nature of the information, I wont be able to assist you there, as it should be highly classified.

Also isn't this your job to know this?

So to make it simply. Create an access db, create each in the access db, and write queries to it. Would be simpler.

 

[Corelli]

Clearly you don't know DATA.

Crown Jewels of Info means Names + Something else (ie salary, medical, etc)

 

[Cray]

I understand the identity issue, the report I do for them wont contain any personal info, only names, then racial, gender, salaries, things like that. Dept of Labour requires this from me for employment equity.

:erm:

http://www.mondaq.com/southafrica/x/631666/Data+Protection+Privacy/Compliance+With+The+Protection+Of+Personal+Information+Act+Are+You+Ready

"Personal information", in the context of POPI, means information relating to an identifiable, living, natural person, and, in certain instances, to companies, close corporations, trusts and other juristic persons and, includes:

information relating to the race, gender, sex, pregnancy, marital status, national, ethnic or social origin, colour, sexual orientation, age, physical or mental health, well-being, disability, religion, conscience, belief, culture, language and birth of the person;

any identifying number, symbol, email address, physical address, telephone number, location information, online identifier or other particular assignment to the person;

the name of the person, if it appears with other personal information relating to the person or if the disclosure of the name itself would reveal information about the person;

information relating to the education or the medical, financial, criminal or employment history of the person;

the biometric information of the person;

the personal opinions, views or preferences of the person;

correspondence sent by the person that is implicitly or explicitly of a private or confidential nature or further correspondence that would reveal the contents of the original correspondence;

the views or opinions of another individual about the person.

 

[LaraC]

Hey there,

I'm busy with a report for dept of Labour, regarding employment equity. I have a long list of employees with all their details in one workbook, but I need to make a new workbook, and work with the data in workbook 1. I will have to create tabs for example (African male, African Female, White male, etc etc.) This way the data in workbook 1 gets sorted in workbook 2 individual tabs. But I want this to be automatically added to workbook2 whenever I add or change employee details in workbook 1.

Is this possible, and can someone pls guide me a bit in the right direction? Even a tip on what to google, as I cant find the right solution or description for what I need in google.

Thanks a million

Did you consider using a PivotTable to display the data you want instead of exporting it to different sheets?

 

[blue-eye-boy]

Did you consider using a PivotTable to display the data you want instead of exporting it to different sheets?

Will check this out too, after this thread I have a few routes to try.

Thanks a million.

 

[conradbethel]

Nice suggestions. I am also wondering but a little bit different query

 

[Urist]

1: Type in "female black" in the first row, copy that, press ctrl+shift and the down arrow, paste.
2: Delete the summary sheet you created, and make a pivot table.
3: Brief your employees that they identify as female blacks from now on.