G
Guest
I want to create a workbook with 4 worksheets, one for each quarter. On each
worksheet I want the 1st three columns to be LastName, Firstname, StudentId.
The data in these 1st three columns needs to be the same on all 4 worksheets.
Ideally, I would like to enter this data once and have it appear in the 1st
three columns of the 2nd through 4th worksheet. The 4th through Nth columns
will contain grades for each quarter's assignments. I would use this type
workbook for each of my 6 classes. I need to keep track of about 150 students.
I could select all four worksheets and enter the data that will be common to
all sheets. The problem w that is that as soon as I ungroup the sheets the
common data is no longer maintained as "shared" across the worksheets.
TIA
worksheet I want the 1st three columns to be LastName, Firstname, StudentId.
The data in these 1st three columns needs to be the same on all 4 worksheets.
Ideally, I would like to enter this data once and have it appear in the 1st
three columns of the 2nd through 4th worksheet. The 4th through Nth columns
will contain grades for each quarter's assignments. I would use this type
workbook for each of my 6 classes. I need to keep track of about 150 students.
I could select all four worksheets and enter the data that will be common to
all sheets. The problem w that is that as soon as I ungroup the sheets the
common data is no longer maintained as "shared" across the worksheets.
TIA