I have two sheets and I'm trying to figure a way to display multiple rows
from sht1 to sht2.
sht 2 A1=apple

sht1
A B C
1 apple grn 21
2 pear yel 22
3 orange org 23
4 apple red 24

sht2
A B C
1 apple
2 apple grn 21
3 apple red 24
How can I get sht2 to display rows of apples? thanks, greg

I'm pretty sure a Pivot Table would solve your dilema.

Use column headings above your data Fruit, Type, Amount, etc.

When setting the layout: ROW:Fruit,Type , DATA:Amount

Then you can select any combination of Fruits and Types to display.

Does that help?

--
Regards,
Ron