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