Users database question
I would like to have the ability for (lets use the number 3 for example)
three employees to enter data into their own spreadsheet or database. I would like for person 1 to be able to see everything that they have entered, but not what person 2 and 3 have entered. The would also apply to any other user. Then, I would like to have all 3 of their data to be consolidated as it is entered into one database that I only will have access to. Can this be done in Excel or would access be better? Thanks, |
I don't use access, but if you're concerned about security in excel, then you'd
have to share different workbooks with each user--only data for that user in that user's workbook. (Security in excel isn't good enough to keep the really curious out.) Pam Coleman wrote: I would like to have the ability for (lets use the number 3 for example) three employees to enter data into their own spreadsheet or database. I would like for person 1 to be able to see everything that they have entered, but not what person 2 and 3 have entered. The would also apply to any other user. Then, I would like to have all 3 of their data to be consolidated as it is entered into one database that I only will have access to. Can this be done in Excel or would access be better? Thanks, -- Dave Peterson |
All times are GMT +1. The time now is 06:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com