Hi Dread,

You can use Data, Filter, Auto Filter. Then you can copy what you have
selected- it will select only those in the active filter.

Does that help?

PB

"dread" wrote:

I have a workbook with numerous worksheets. Each worksheet represents a
category (ie: cabinets, countertops, appliances). In each worksheet I have
a listing of options. Options are selected by entering a Yes in the select
column.

Heres what it looks like:
Category: Option: Select:
Worksheet 1
Cabinets Oak Yes
Cabinets Cherry No
Cabinets Mahogony Yes
Worksheet 2
Countertops Brown Granite No
Countertops Green Granite Yes
Countertops Marble No
Countertops Laminate Yes

I want to transfer all the Yes options from each of the Category worksheets
(Worksheet 1 and Worksheet 2) to another worksheet (Worksheet 3). How can I
do this so that Worksheet 3 doesnt contain blank lines(the No selections)
between each category?

Thanks.