VBA for variable range

[michael]

Help

I have a spreadsheet with suppliers against a number of
products. I want to be able to identify each supplier and
then copy just their products to another book. The number
of products can change every time the report is created.
Supplier 1 Product a
Supplier 1 Product b
Supplier 1 Product c
Supplier 1 Product d
Supplier 1 Product e
Supplier 1 Product f
Supplier 1 Product g
Supplier 2 Product a
Supplier 2 Product b
Supplier 2 Product c
Supplier 2 Product d
Supplier 3 Product a
Supplier 3 Product b
Supplier 3 Product c
Supplier 3 Product d
Supplier 3 Product e
I want to take all Supplier 1 then Supplier 2 and so on
for any number of suppliers.
Any help would be appreciated
Thanks
Michael

 

[Ron de Bruin]

Debra have a example on here site to copy to a sheet(not a workbook)
http://www.contextures.com/excelfiles.html#Filter

I think you need this one
***Create New Sheets from List *****