Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What formula do I use to link worksheets together within one spre.
I use Excel to record my students grades. The first worksheet is the student
summary which keeps track of the students semester on going grade. The 2nd, 3rd, and 4th worksheets keep track of the students grades by standards. I want each individual student's grade from the standard worksheet to link into the first summary page. Is there a formula I can use to link a grade from another worksheet into a different worksheet? |
#2
|
|||
|
|||
If your grade you want to link is on sheet 2 in cell A1 use this.
=Sheet2!A1 Steve "Juarez1" wrote in message ... I use Excel to record my students grades. The first worksheet is the student summary which keeps track of the students semester on going grade. The 2nd, 3rd, and 4th worksheets keep track of the students grades by standards. I want each individual student's grade from the standard worksheet to link into the first summary page. Is there a formula I can use to link a grade from another worksheet into a different worksheet? |
#3
|
|||
|
|||
You can have XL create the formula for you.
Right click in the cell containing the grade you wish to link, and choose "Copy". Navigate to the summary sheet, and right click in the cell that will "receive" the data, and choose "PasteSpecial". Then just click on "PasteLink". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Juarez1" wrote in message ... I use Excel to record my students grades. The first worksheet is the student summary which keeps track of the students semester on going grade. The 2nd, 3rd, and 4th worksheets keep track of the students grades by standards. I want each individual student's grade from the standard worksheet to link into the first summary page. Is there a formula I can use to link a grade from another worksheet into a different worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you link 2 worksheets together? | Excel Discussion (Misc queries) | |||
formula in different worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Can't link cells in worksheets in same workbook | New Users to Excel | |||
count formula between worksheets | Excel Discussion (Misc queries) |