Sending data from one spreadsheet to another

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

I have two tables.... Table 1 and Table 2.What I need to
do is extract specif data from one Table 1 to TAble 2.
PLease see below:

TABLE 1
A B C D
Login Total questions #of attemps score
1100 19 19 100
1200 19 22 85
1300 19 25 65

TABLE 2
A B C
Agent Name Login TAken Test?
John Doe 1100 (score needs to be here)
JAne Doe 1200 (score needs to be here)
David Smith 1300 "" ""


I am trying to get datat from one page to the next. I
need to get the score from Table 1 to get to table 2 but
also to align with the login as well.If I fill out TAble
1 I need it to automatically update table 2. Can someone
please help me with this?

PLease explain..

Thanks in advance

S
 
Try this:

Assume your Table 1 is in Sheet1,
cols A to D, data from row2 down

In Sheet2
---------
assume your Table 2
is in cols A to C,
data from row2 down

Put in C2:

=IF(ISNA(MATCH(B2,Sheet1!$A:$A,0)),"",OFFSET(Sheet1!
$A$1,MATCH(B2,Sheet1!$A:$A,0)-1,3))

Copy C2 down as many rows as there is data in col B

Col C will return the scores that match the "Login" ids
in col B from the data in Sheet1

Unmatched "Login" id(s) will return blanks [""]
 
Back
Top