thanks tom and Dave. Dave, the website u gave i came across just now but my
office cant open all these zip files. that y i cant view those.

"Tom Ogilvy" wrote:



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

has code to do that.

--
Regards,
Tom Ogilvy


"violet" wrote in message
...
i have a master sheet where all the data is. colb contain country name. i
will like to use a macro to filter them and auto create a new sheet for
each
country copy teh relevant data to the new sheet. how can i do that?