I wish to click on a single cell and have a row of data show
elsewhere.
i.e I have four rows of data in a worksheet.
One is green one red one yellow and one white.
When I click on the red cell I want the data from my red collectio
entered in a selected row.
When I click on the green cell I want the green collection entere
where the red collection was.etc etc
Can this be done?
TIA
Regards from Africa
Aussiemik