Hi blk,

It looks like you are getting close to doing this without our help.

The reason for the error is that I wrote the AdvFilter subroutine to work on the workbook I attached. It had a sheet named "SalesStuff". You don't have a sheet named this on your example so the code is lost. If you want to use my code you need to understand it enough to modify it to work with your sheet names. I gave it to you as an example of what you might do. It was never intended to work on any workbook, only one with the correct sheet name and criteria range. You will need to do a few Advanced Filters by had to understand the code I wrote also.

hope this helps.