Help sorting an excel sheet [Closed]

Question

Help sorting an excel sheet [Closed]

Report

JillMaree - May 5, 2010 at 02:08 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- 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?

Help sorting an excel sheet
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Auto notify of email when excel sheet updated ✓ - Forum - Excel
Comparing columns in two different excel sheets and if they match copying third column ✓ - Forum - Excel
How to take screenshot in excel sheet - How-To - Excel
How to copy data from one excel sheet to another - How-To - Excel

2 replies

Ask a question

rizvisa1 · Answer 1 · 2010-05-05T05:59:48-0400

Answer 1 / 2

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
May 5, 2010 at 05:59 AM

Are you saying that you want them not to see the score of others?

JillMaree · Answer 2 · 2010-05-05T08:41:04-0400

Answer 2 / 2

JillMaree
May 5, 2010 at 08:41 AM

Yes! Thank you I was a bit tired last night as well!

Report

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
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

Help sorting an excel sheet [Closed]

2 replies

Your reply

Subscribe To Our Newsletter!