Hi
I think this is easy to do, and I can probably show you a few ways to do it, both by
refining your macro recorded coding,
and
other ways starting from scratch.

But it will be an awful lot easier for me if you can upload two workbooks.
One showing Before and the other showing After you ran the macro.
Then I can write you coding, check the results and return a workbook.
Otherwise I have to make up a workbook myself, and I don’t have the time

( By the way, if you ever need urgent help, its best to ask at the major forums, such as excelforum.com or mrexcel.com. There are a lot helpers there 24/7
I will answer all questions I can here, but I only pop by here once in a while. ( Currently not many other people pop by here. ) )

Alan

( Important: Most forums have a “Cross post” Rule – you must tell everyone everywhere when you post the same question at different forums )