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



"Jessie" wrote:

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)