Do your list criteria and copy to ranges have headers? They should and you
will need to include the header rows when you specify the range for these in
the advanced filter.



"alisonmacd" wrote:


Ok, managed to concatenate names and have put small under large so I can
see everything together.

However can not get Excel to only take those rows that have a Name
match in the smaller.

For the advanced filter I've tried to tell Excel that the list range is
A1:I34500 (I'm assuming the whole of the large one needs to be covered
here), the list criteria is G34505:G34750 (the column that has the now
concatenated Names) and to copy the range to A34755 (blank space under
both). When I try this though it basically replicates the large sheet
rather than only pulling out all rows where it's found a match of Name
on the small.

I just want to tell it that if the Name on the large is also a Name in
the small then pull out that row. I have shown what I'm trying to
achieve below, the totals can be done manually if I can't find a way to
get the filter to do it or find a simple way to code it.

Alison.

E.g.
large
Name Number Subject1 Subject2
A,A 1 4 2
A,A 3 2 3
B,B 2 1 2
C,C 1 3 3
C,C 2 2 3
D,D 3 4 1

small
Name
A,A
D,D

medium (filtered large)

Name Number Subject1 Subject2
A,A 1 4 2
A,A 3 2 3
total 6 5
D,D 3 4 1
total 4 1


--
alisonmacd
------------------------------------------------------------------------
alisonmacd's Profile: http://www.excelforum.com/member.php...o&userid=24323
View this thread: http://www.excelforum.com/showthread...hreadid=379283