Linking information within a spreadsheet
 

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?

Linking information within a spreadsheet
 

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?

Linking information within a spreadsheet
 

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.

"Don Guillett" wrote:

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?

Linking information within a spreadsheet
 

If you have a lot of places to put the same info you use a macro in the
sheet module.
right click sheet tabview codeleft window select worksheetright window
select worksheet_change


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

--
Don Guillett
SalesAid Software

"azvlr" wrote in message
...
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.

"Don Guillett" wrote:

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?

Linking information within a spreadsheet
 

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.

"Don Guillett" wrote:

If you have a lot of places to put the same info you use a macro in the
sheet module.
right click sheet tabview codeleft window select worksheetright window
select worksheet_change


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

--
Don Guillett
SalesAid Software

"azvlr" wrote in message
...
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.

"Don Guillett" wrote:

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?