Help sorting an excel sheet

Closed
JillMaree - May 5, 2010 at 02:08 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 5, 2010 at 08:48 AM
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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
May 5, 2010 at 05:59 AM
Are you saying that you want them not to see the score of others?
0
Yes! Thank you I was a bit tired last night as well!
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
May 5, 2010 at 08:48 AM
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
0