Creating written summary in excel 2002

[hkg003]

Hello, I am creating a financial summary on a worksheet and I want to be able to write up a summary about each category. Is there a way that I could write text on my worksheet and create a parameter where my text could go to the next line such as a word document?

I hope I made myself clear.


Thanks

 

[theozz]

Want this ?
cell a1 has Validation
and cell a1 selected 1 cell b1=Validation 1
and cell a1 selected 2 cell b1=Validation 2
and cell a1 selected 3 cell b1=Validation 3
and cell a1 selected 4 cell b1=Validation 4

and cell b1 selected Validation 2 then cell c1=Validation 21
and cell b1 selected Validation 3 then cell c1=Validation 23

Like this???

 

[hkg003]

Im sorry Theoz for my ignorance, but could you create an example with your formula?

Thanks

 

[hkg003]

bump

 

[hkg003]

bump