I know this is old but, this almost fits perfectly for what I need. The only problem is that I lose all my formated/merged cells when they are copied downward. What can be added to this that can keep the formatting of the copied cells?

Thanks