I am using excel to create a estimate product list and a spec. sheet of the
products selected.

on sheet 1 named "Estimate Template" I have the choice such as
Roof Cost Quantity
Total
Shingles $60 200 sf
$120 Yes
Metal $80 200 sf
$160 No

I have a "Yes" in the next cell for the row that I select. How Do I get only
the row I select with a "yes" to show up on another sheet named "Spec. Sheet"?