Linking data between spreadsheets

N

Nancy

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!
 
O

OssieMac

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
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Marking cell; totaling all # between marked cell & next marked cel 4
how do i see which data matches between two worksheets? 1
Lookup and return value 8
vlookup help linking data between worksheet 3
using excel as a markbook 1
IF then SUM 5
countif from different worksheets 2
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1

Top