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