Linking data between spreadsheets
 

Worksheet 1 has student ID's with the names in alpha order.
Worksheet 2 has students listed by class, with daily attendance columns that
adds up in a total column.

I need the attendance total column for each student, according to ID, on W2
to also appear in a totals column on W1 for the correct student.

So basically I need the totals column to match the student ID# on both
worksheets.

How do I do this?

thanks!

Linking data between spreadsheets
 

Hi Nancy,

VLOOKUP formula will possibly do what you want. If you can't work out how to
create the formula can you post the following info:-

The column id for the student id on W1
The column id for the student id on W2
The column id for total attendance on W1
The column id for total attendance on W2

--
Regards,

OssieMac


"Nancy" wrote:

Worksheet 1 has student ID's with the names in alpha order.
Worksheet 2 has students listed by class, with daily attendance columns that
adds up in a total column.

I need the attendance total column for each student, according to ID, on W2
to also appear in a totals column on W1 for the correct student.

So basically I need the totals column to match the student ID# on both
worksheets.

How do I do this?

thanks!

Linking data between spreadsheets
 

Hi Nancy,

VLOOKUP formula will possibly do what you want. If you can't work out how to
create the formula can you post the following info:-

The column id for the student id on W1
The column id for the student id on W2
The column id for total attendance on W1
The column id for total attendance on W2

--
Regards,

OssieMac


"Nancy" wrote:

Worksheet 1 has student ID's with the names in alpha order.
Worksheet 2 has students listed by class, with daily attendance columns that
adds up in a total column.

I need the attendance total column for each student, according to ID, on W2
to also appear in a totals column on W1 for the correct student.

So basically I need the totals column to match the student ID# on both
worksheets.

How do I do this?

thanks!