Grades

[boogie]

Any help would be appreciated. I am thinking if this is possible. I have all
the records set up. Students have their ID number on Col A. Students name on
Col B and Grades on Col C. Col D sorts the grade automatically using macro.
This is my dilemma. I want to let my students see their records on the
network. Let say if they enter their ID number on a switchboard, they will
see their name, rank and grades. Is that possible with excel? Thanks.

 

[John Wilson]

boogie,

Is that possible with excel?

Anything is possible with Excel

Let say if they enter their ID number on a switchboard

Do they know each others ID number??
Will you need a password too?
Will you assign and manage the passwords or will they need
to be able to change their passwords themselves??

This is more of a project than a question so I can't answer
everything here, but I'll give you a start. Take it one step at
a time and keep posting back when you get stuck and I'm
sure that someone will help you get to your final solution.

One scenario.......(for ID# only, no passwords)
Take your data sheet and make it VeryHidden
(that way no one can see it, or unhide it).
In the Workbook_Open event, call up a UserForm
On that UserForm will be a TextBox to put in an ID#.
When a valid ID# is entered, Labels on that UserForm
will populate with whatever data that you have for that
ID#.

What you want to do can be done.

John