Looping would loop through a list of unique items (also can be built with
advanced filter) and would put each of the items in this list as criteria in
the criteria cell/range, adjust the destination (which would be a variable
in the advanced filter command), then execute the filter. Perform any
remaining administration.

I have successfully used this many times as I am sure you have yourself. So
apparently my suggestion was not clear or was vague as to what I meant.
Thanks for pointing that out.

--
Regards,
Tom Ogilvy


"Nate Oliver" wrote in message
...
"wtpcomplab" wrote:
I need to keep this in excel if I can.

Right, this is all in Excel. Excel can act as a Jet DB as well. I wrote
the
code in Excel for Excel and even tested it. One potential issue is that
your
data table would really need to look like a DB.

Tom's suggestion is more straightforward although I'm not sure about
looping. You could pass the copied, filtered data to a new workbook, save
and
close.

Bon chance,
Nate Oliver