See Ron de Bruin's site:

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

--
Regards,
Tom Ogilvy


"Darrell Lankford" wrote in message
oups.com...
I have for example 500 rows of information with column A having item
numbers 123-11-001, 123-11-002, etc... I have the autofilter on so I
can pick item 123-11-001 which has 10 rows of information and
123-11-002 that has about 20 rows of information. I have about 20 items
and I have to pick each item individually to print them. Does anyone
have a code so that it filters each item and prints each sheet
filtered? Any help would be greatly appreciated.
Darrell