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