| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions | |||
| how do i remove routing information from saved excel spreadsheet | Excel Discussion (Misc queries) | |||
| Linking Information in Sheets based on its content | Excel Worksheet Functions | |||
| Linking information between workbooks | Excel Worksheet Functions | |||
| Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Linear Mode
