Changing row content with single cell click

[aussiemike]

I have four cells across the top of a row.
Green, blue, red, yellow.
I have a column of ten cells just under the top row.
I am trying to work it that when I click the green cell at the top
getone set of figures and when I click the red cell I get another.
Can anyone point me in the right direction.
Regards
Aussiemik

 

[Dav]

You will have to give us a little more information, it can be done wit
macros, data validation (if you choose the colour from a drop dow
list), but depends on the data you wish to return, and if the data wil
be added to in future or is always the same information

Regards

Da

 

[aussiemike]

Thanks Dav,
The date i wish to appear will remain the same.
What it is is a golf program and I wish that anyone playing from the
green tees sees the meters for each hole.
If you are playing from the white tees then you click the white cell
and you see the didstances from that tee.
For space purposes I wish the data to appear in the same column. The
dat will not change.