Filtering data and replace on to an new worksheet

[Guest]

I have a lot of info about different suppliers on one datasheet and I would
like to divide this into different sheets. This way I can find the info of
each supplier on a separate worksheet and I look at the result of all my
suppliers separately.
Is this possible?
(I'm trying to put this action in a macro, so I can look the results of all
my suppliers whenever I want)

 

[Ron de Bruin]

Hi Jessie

Try this
http://www.rondebruin.nl/copy5.htm

 

[Guest]

You might consider just using the AutoFilter to filter out only the Supplier
you are interested in at the time.

Vaya con Dios,
Chuck, CABGx3