Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2
JillMaree
May 5, 2010 at 08:41 AM
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