Linking information within a spreadsheet

A

azvlr

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

Don Guillett

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

azvlr

Thank you Don. I am using the =soursheet!A1 option. This is working,
although a little tedious. I did figure out that I can put one
=sourcesheet!a1 reference, and then copy and paste it into the other cells,
so that cuts down the workload. I am not clear on your second suggestion,
worksheet_change event. Could you elaborate? Thanks.
 
D

Don Guillett

If you have a lot of places to put the same info you use a macro in the
sheet module.
right click sheet tab>view code>left window select worksheet>right window
select worksheet_change


target.copy sheets("sheet1").range("a1")
 
A

azvlr

Don,
Thanks for your prompt and helpful reply. I see that creating a macro is
the way to go. I have never used Visual Basic before, so I feel a little
intimidated. However, I think I can create a pretty sophisticated grade book
with a little work and your suggestions. I will definitely play around with
it. Thanks again.
 
Top