Previous Topic Next Topic

Help sorting an excel sheet

Closed
JillMaree - 5 May 2010 à 02:08
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 May 2010 à 08:48
what formula or marco could I use to allow employees to just bring up their data on a spread sheet using their ID
IE

Col. D is all the IDS F and G are the scores

I only want them to be able to bring up theirs is there away that they can imput their ID just pull up the data tied to the ID?

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 May 2010 à 05:59
Are you saying that you want them not to see the score of others?
Réponse 2 / 2
JillMaree
5 May 2010 à 08:41
Yes! Thank you I was a bit tired last night as well!
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
5 May 2010 à 08:48
I don't think you can prevent them from seeing other score. How ever you can have a sheet where they might enter an id, and record relevant to that id shows up

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
Creating 1 master sheet from data from multiple sheets
ExcelNoNothing -
vcoolio -

1 response