Morning all,
I want to know the vba code to merge and unmerge cells. The following table is the information I have.
<tbody>
</tbody> Dropdown List
<tbody>
</tbody>
Merge option
Merge option
Unmerge option
Unmerge option
As you can see from the table, There is 1 drop down menu that has 2 different selection options. One is the merge option and the other is the unmerge option.
When I input a value from another cell, it triggers one of the 2 (merge or unmerge) options to show on the drop down list. This part I have done.
What I am trying to achieve is when the merged option is selected and when I pick an item from the drop down list, row cell from Code Name/Code No/Code Rate all merge. And then auto move on to the next row to fill another row with the next merge selection.
Likewise to the unmerge option, when I select an item from the drop down list the Code Name/Code No/Code Rate will be filled in from their drop down lists.
Hope this is clear and thanks in advance.
Bluwara
I want to know the vba code to merge and unmerge cells. The following table is the information I have.
<tbody>
</tbody>
Code Name | Code No | Code Rate | Total Amount | Drop Down List | |
AB | 02 | 0.10% | |||||
AC | 05 | 0.013% | |||||
AF | 15 | |||||
BR | 65 |
<tbody>
</tbody>
Merge option
Merge option
Unmerge option
Unmerge option
As you can see from the table, There is 1 drop down menu that has 2 different selection options. One is the merge option and the other is the unmerge option.
When I input a value from another cell, it triggers one of the 2 (merge or unmerge) options to show on the drop down list. This part I have done.
What I am trying to achieve is when the merged option is selected and when I pick an item from the drop down list, row cell from Code Name/Code No/Code Rate all merge. And then auto move on to the next row to fill another row with the next merge selection.
Likewise to the unmerge option, when I select an item from the drop down list the Code Name/Code No/Code Rate will be filled in from their drop down lists.
Hope this is clear and thanks in advance.
Bluwara