Hi,
there is no automatic way to do this. You could automate it fairly simply
by turning on the Macro recorder and using Advanced Filter in the
DataFilterAdvanced Filter and click on the copy to another location
button. Then it would be fairly straightforward, depending on your
competence level of course, to adapt the code to pump out the sheets.

Hth,
Oli

--
Message posted via http://www.officekb.com