Listing Sales Records etc

[bugmcw]

All,

I have a dataset containing information regarding sales. Every time a salesperson makes a sale, their name and all of the information gets put into an excel document. Here is my dilemma:

Richard makes 10 sales, Sally makes 9 sales.

What i would like to do is take the dataset that includes all 19 records, and print each persons sales on a separate sheet within the workbook. So when i update SHEET1 (containing the raw sales data), the sheet titles RICHARD will update with his newest sales information.

Any idea how I can accomplish this?

Thanks again-

Bug

 

[bugmcw]

UPDATE: I found I CAN do =if(b1="Richard",b2,"") and it works if b1 is, in fact, Richard, but when i have thousands of records, there are a bunch of blanks that make it unworkable for regular use (and especially for client facing documents) any other ideas?