Thanks Paul
I saw the attachment you recommended prior to asking for help in this forum but that didn't help me. so here I am.
My concern is cleaning up the table after the merge because most of the times users have blank rows in the table after merging. Running a macro to do that would be my answer but initiating that macro after the merge without user having to click a button, is what I am having a problem with.