Filter would work, However, I don't want to show all columns in the "new" file and I would like to have a different format since this "new" file will be send out to customers.
Requirement 2 would not be so important (believe this is the most difficult).

I found this post:
http://www.excelforum.com/excel-gene...onditions.html

In its core it does what I need (I need only one criteria). However, I can't figure out how they did this.