Hello there!
Some time ago I found 2 VBA code blocks on the internet that allow me to do the following:
* automatically merge all cells with the same value in the active worksheet
* automatically unmerge all merged cells in the active worksheet without data loss (the original value of the merge cell is being copied to all unmerged cells - as a result I do not have any blank cells)
The problem is that the above code works only on row level (horizontally), and I need it in both directions (horizontally and vertically).
I will try to illustrate with 2 examples:
Current situation:
https://imgur.com/v7e3M7q
Desired logic:
https://imgur.com/ULfDs3y
Is it possible to achieve the desired logic through VBA coding?
Kind regards,
Vladimir
Some time ago I found 2 VBA code blocks on the internet that allow me to do the following:
* automatically merge all cells with the same value in the active worksheet
* automatically unmerge all merged cells in the active worksheet without data loss (the original value of the merge cell is being copied to all unmerged cells - as a result I do not have any blank cells)
The problem is that the above code works only on row level (horizontally), and I need it in both directions (horizontally and vertically).
I will try to illustrate with 2 examples:
Current situation:
https://imgur.com/v7e3M7q
Desired logic:
https://imgur.com/ULfDs3y
Is it possible to achieve the desired logic through VBA coding?
Kind regards,
Vladimir