Hi MarvinP,

Thanks for the spreadsheet. I figured out what I was doing wrong in the Advanced Filter – not including all the column headers in the criteria and range. Also, the VBA is a great idea. Since I know how to record macros, I was able to add Advanced Filter VBAs easily. Thanks again for all your help.