Automatically define names

[Guest]

Hello All.

I was wondering if it is possible to automatically define names based on a formula.

For example if cell a1 = yes, name a1 "YES1". if cell a5 = yes, name a5 "YES2". Etc...

I hope the above is clear enough to understand. Thankyou all in advance for your help.

 

[dlmandalia]

You're welcome Sam.

Hi I wanted to define names automaticly from Row Column Head

Example
Ahmedabad Bombay Kolkata
Apple 10 14 17
banana 11 15 18
Orange 12 16 19

I want to automaticaly define name for 10 as AhmedabadApple, 11 as AhmedabadBanana, 14 as BombayApple so and so forth.
I don't know how to do that. Please help me on it.

I tried find out the function for it but think there is none. I am also not that good at VB. Would please give me micro by which I can do it.

Many thanks,

Dipen Mandalia