Use a filter, preferably autofilter which is easier to learn, filter on the
Rep

--
Regards,

Peo Sjoblom


"Dixie" wrote in message
...
I am trying to use each Rep's name to bring back all their customers and
corresponding data. VLookUp continually brings back the first customer's
name only. I need all customers' names and data that use the Rep. So,
for
Sheet#2, Column (A) has all the Reps, Column (B) has all the customers,
Column (C) has the dollar amounts, and Column(D) has the dates. If Sheet
#1
is for RepXX, I need to bring back to Sheet#1, all Customers, dollars, and
dates that use RepXX. (a mix of text and numbers). Any help on this
would
be greatly appreciated.
-Dixie