Advanced Filter?

[craymer]

I have a simple workbook with two worksheets, "Sections" and "Equipment." I would like to copy the "Section No." and "Section Description" columns to the "Equipment" worksheet only if the "Equip?" column says "Yes." I would like to do this without having to do a macro if possible where it instantaneously showed up on the "Equipment" worksheet.

Is this possible?

https://www.dropbox.com/sh/0bc2ew9na20u9pu/u09HOVzIJ4

 

[Hui]

Craymer
Have a read of the technique Luke describes here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/