Help sorting an excel sheet [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Are you saying that you want them not to see the score of others?
Yes! Thank you I was a bit tired last night as well!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!