Is it possible to create an excel sheet where only I can read it but others can add to it

[Stacker]

So I often have to get people’s names and other personal information for work but from different departments. I was wondering, is it possible to create an excel sheet where people can copy and paste rows of data to the file but are unable to read anything outside of the headings unless they have the password? I am hoping that a rigid template will not only help in data collection but also with regards to privacy since people will not be able to see people’s info from other departments unless they have a password.

Thanks.

 

[dmt32]

If you have sensitive data then Excel is not a platform to store it less so, in a workbook that others can share. Security is weak and any one with a good understanding of Excel can unlock a workbook.

If you need to provide ability for users to submit data centrally then one workaround you could consider is to provide them with a macro enabled template that writes its the data to common workbook (database) on your corporate network.
The workbook can be password protected to open it to provide a level of security. You as Admin can then extract the data from it to you master workbook that is on another drive which contains the sensitive data and only you have access to.

Its a bit convoluted but at should provide a barrier against unauthorised users accessing sensitive data.

Dave

 

[Stacker]

The data is not even encrypted when sent to me. I was thinking if either (trying to) use VBA to do something like this.

Input box: what is your name?

Drop down menu: select their department

Then people will copy and paste their names, department, date and result into a certain template.

Save and close.

 

[dmt32]

Its just a suggestion to give you ideas of an approach that negates need for users to have access to a workbook that contains sensitive data but really only you can determine if idea would work or not.

Others here may be able to offer alternative suggestions.

Dave

 

[Stacker]

It’s not ultra sensitive. Like I could use power query have them save the files in a certain network location but I think this way might be better.