Merge and unmerge cells based on cell value.

Hi all,

I'm looking for a macro to merge and unmerge specific cells in a column based on their matching their value.

Essentially what I need the macro to do is:
1. Unmerge and erase values in cells K11 to K50.
2. Paste a formula from cell K10 down to K11 until K50 (its a vlookup formula which will copy down appropriately)
3. Based on the values from the formula in cells K11 to K50, merge surrounding cells that have the same value. This formula does this step -> I've posted it just for reference.

Please Login or Register  to view this content.

Therefore each time this macro is called, it would erase & unmerge the current data in K11:K50. Copy the formula in K10 down to K50 and based on the formula's value, merge surrounding cells.

Just a couple extra things:
Could this simultaneously do this over three sections? ie. K10,K11:K50, U10,U11:U50, AE10,AE11:AE50
I'm not concerned with potential slowdown due to macro calculation.
Could the text be left aligned.
Could this macro be 'called' in the following formula:

Please Login or Register  to view this content.

Thanks for reading!