automating with merged cells

[karthuappu]

[FONT=&quot]I need to update this table of sorts every week, i have made 3 iterations for the same in the sheet attached. But in the main sheet i only have one table within which all modifications would be done. The process usualyy takes a few minutes is there any way to spped it up using either macros or anything else.[/FONT]
[FONT=&quot]can someone please help.[/FONT]
[FONT=&quot]Thanks.

Also posted on
[/FONT]https://chandoo.org/forum/threads/automating-with-merged-cells.41896/

Im unable to attach the file here it is attached to the other link

 

[Kamolga]

Solved here https://chandoo.org/forum/threads/automating-with-merged-cells.41896/#post-249649