I'm guessing this needs to be done with VBA (which I just can't seem to grasp!
Any help would be appreciated:

I have a spreadsheet with 6,000 rows of data, "part number" "vendor" "Quantity" "price", where as:

1234 SONY 10 299.95
4321 SONY 12 59.95
WC5T WHOEVER 1 5.74

I'm hoping that someone can help me with a formula that will create new worksheets with the name of each "Vendor" (there are about 30 unique vendor names) and move (or copy) all of the rows of data for that vendor into the "Vendor" worksheet. Sounds impossible.

What do you think?

Thanks, Steve