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