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

In each of the cells of sheets 2, 3, and 4 put:
=sheet1!A1
for cell A1 and likewise for the other cells on your added sheets.

You can have Excel do this by clicking in cell A1 of sheet 2, typing "=",
then click on the sheet 1 tab, click on cell A1 and pressing enter. Then you
can autofill the rest of the column and the other columns.

Larry

"Onceler" wrote:

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

Larry,

Thanks for the tip. I searched the online help and didn't find much. Do you
think this is the only way to do it?

Onceler

"lar.ridge" wrote:

In each of the cells of sheets 2, 3, and 4 put:
=sheet1!A1
for cell A1 and likewise for the other cells on your added sheets.

You can have Excel do this by clicking in cell A1 of sheet 2, typing "=",
then click on the sheet 1 tab, click on cell A1 and pressing enter. Then you
can autofill the rest of the column and the other columns.

Larry

"Onceler" wrote:

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