on the destination sheet you can use
=sourcesheet!a1
or a worksheet_change event if you have many sheets to transfer the info to
more info?

--
Don Guillett
SalesAid Software

"azvlr" wrote in message
...
I am trying to create my own gradebook spreadsheet because my school won't
let me load a commercial program other than the one they use. I find that
it
is not adequate, so I'm making my own.
What I want to do is have information that I type on one worksheet update
automatically onto other sheets. I want to have one data entry page, then
have a student's scores transfer to his or her own page.
I find if I set up a hyperlink, it takes me to that information rather
than
allowing me to enter new data.
I know I can also type in "=" and then reference the original cell, but
this
is very tedious to several times for 60+ students.
Is there a faster way to do this?