On Apr 5, 8:35 pm, u473 wrote:
I did appreciate your code, it works and I am still going thru it to
learn.
But I was not trying to sum the filtered data, just listing the
filtered data
as shown below. The modif is probably minor but I cannot figure it
yet.
Thank you again
Celeste

Sheet1 :
Customer
B
G
K

Sheet2 :
Invoice Customer Product
100 K 200
101 L 201
102 B 202
102 B 403
105 K 307
106 A 251
107 B 525

Sheet3: (Filter Result)
Customer Invoice Product
B 102 202
B 102 403
B 107 525
G
K 100 200
K 105 307

Celeste, be aware that you could probably use a list of customer names
and a autofilter to get the required format if you're so inclined to
do it that way .... but this code does work pretty well :P

HTH

Chris