Question: Excel Formula? I have a sheet on excel called 'OrderingSheet' and in A5:A60 there is a product name and in the cells J5:J60 it says YES or NO dependant on another value. I need a formula which will show, on a sheet called 'OrderForm', the product names if it says YES.

Answer: 1. In the "OrderingSheet", click Data > Filter > Autofilter\n2. Use the filer in J column to select the "YES" only\n3. Copy the product names in A column & paste them to "OrderForm"\n4. If you have certain format/font that you have setup in the "OrderForm" sheet, and it's different from the format in "OrderingSheet" page, then use copy & "paste special" (under "Edit"), then select "paste value" - this will let you preserve the format setup in "OrderForm"
This question from the Yahoo Q&A forum is categorized in the topic: Business & Finance