dlmandalia
New Member
- Joined
- Jul 6, 2012
- Messages
- 12
Hi I wanted to define names automaticly from Row Column Head
Example
<TBODY>
</TBODY>
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 macro by which I can do it.
Many thanks,
Dipen Mandalia
Example
Ahmedabad</SPAN> | Bombay</SPAN> | New York</SPAN> | |
Apple</SPAN> | 10</SPAN> | 13</SPAN> | 16</SPAN> |
Banana</SPAN> | 11</SPAN> | 14</SPAN> | 17</SPAN> |
Orange</SPAN> | 12</SPAN> | 15</SPAN> | 18</SPAN> |
<TBODY>
</TBODY>
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 macro by which I can do it.
Many thanks,
Dipen Mandalia