May Jun Jul
Apple No Yes No
Pear Yes No Yes
Orange Yes Yes No

1) I would like to use a macro to go through the above table (using I think
a range, a loop and a if) and for every "Yes" I want to copy out the "Fruit
Name" & " the "Month Name" into seperate columns in another worksheet
(example below)
Apple Jun
Pear May
Pear Jul
Orange May
Orange Jun

2) My actual data table is larger and may expanded in both directions. If I
define a name for the range in Excel, can I use this named range in a macro?

Many thanks in advance for any help possible
Steve