"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