Description: http://www.excelfox.com/forum/f2/vba...criteria-1357/

I need this by the end of the day (US time) and will pay promptly via PayPal upon successfully testing the macro.

I require it to be flexible for if the mergers/name changes table grows and for example if multiple sets of rows need to be merged (multiple mergers in one quarter). And, please optimize the code as much as possible.

Thank you