Thanks Romper, that seems like that will work, but I'm having trouble understanding how to do the criteria range part. Do I just copy the same range that I have in the List Range part? Also, I really don't want my list on the same sheet as the AutoFilter, but it says that I have to have them on the same sheet whenever I specify otherwise. I haven't messed with AutoFilter a lot in the past so this is kinda all new to me.