Data entry problem

  • Thread starter Thread starter Dathmar
  • Start date Start date
D

Dathmar

Hey there I just spent a few hours trying to come up with a solution t
a problem I am having. The problem is this. I have two exce
spreadsheets that need to be merged. The issue is that one of th
sheets has more info then the last. An example is this

Sheet 1

Subject Markers Tested Markers Complete Markers Concordant
VT1081 24 21 21
VT1119 24 24 24
VT1169 24 24 5
VT1481 24 20 20
VT1538 24 24 24
VT1903 24 24 24
VT2089 24 24 24

Sheet 2

Subject Subject A: ApoE Subject B: ApoE
VT1081 3/3^ 3/3^
VT1119 3/3^ 3/3^
VT1169 3/3^ 3/4^
VT1228 3/3^
VT1387 3/3^ 3/3^
VT1481 3/3^ 3/3^
VT1538 3/3^ 3/3^
VT1666
VT1785 3/3^ 3/3^
VT1903 3/3^ 3/3^
VT2089 3/3^ 3/3^

As you can see there are more subjects in sheet 2 then in sheet 1 and
want to add the info of sheet 2 quickly and easily to sheet 1. I
there anyway of doing it other then just picking and choosing the inf
that I can copy over? :confused:

Thanks for your time. :
 
You could insert a helper column in sheet2 and use it to look for a match:

=isnumber(match(a2,sheet1!a:a,0))
copy down the range.

Then ones that return False will not appear on sheet1.

You could apply Data|Filter|autofilter, filter by False and then copy those
visible cells (in only column A???) to sheet1.

But this would just update the subject list. I didn't see the similarity to the
"data" portion of the tables.
 
Back
Top