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
Lookup and return value 8
countif from different worksheets 2
how do i see which data matches between two worksheets? 1
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
if student number repeats move all data for that number on to same 1
Adding up multiple worksheets by name and totals 5
extracting data from one sheet based on data in another - VLookup? 3

Top