nithishvinolin
New Member
- Joined
- May 31, 2013
- Messages
- 5
Hi,
I need a help in developing a macro.
I have a example. I have 4 columns. first 3 columns ID, C1, C2 have the input data. Under a ID we have multiple number of rows. In this example we have 4 rows for ID1. But in real time it can be any number of rows under a single ID. When I click a button the values under ID 1 should get concatenated and stored under the Concatenate column.
I tried some macros but i cant get the logic behind finding the dynamically changing row counts under single ID. Any kind of help will be appreciated. Thanks in advance.
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
I need a help in developing a macro.
I have a example. I have 4 columns. first 3 columns ID, C1, C2 have the input data. Under a ID we have multiple number of rows. In this example we have 4 rows for ID1. But in real time it can be any number of rows under a single ID. When I click a button the values under ID 1 should get concatenated and stored under the Concatenate column.
I tried some macros but i cant get the logic behind finding the dynamically changing row counts under single ID. Any kind of help will be appreciated. Thanks in advance.
ID | C1 | C2 | Concatenate |
1 | 1 | 2 | 12345678 |
3 | 4 | ||
5 | 6 | ||
7 | 8 | ||
2 | 9 | 10 | 91011121314 |
11 | 12 | ||
13 | 14 | ||
3 | 15 | 16 | 15161718 |
17 | 18 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>