Macro - Copy and Insert Copied cell

I would like to ask help on how to create a macro to copy and insert copied cell. This is the scenario.
1. A2:A200 contains values that has duplicate.
2. Macro should copy the header (a1:e1) and insert it in between the two unduplicate value
example:
a1:e1 = headers
a2:a24 = xxxx
a25:a35 = yyyy
a36:a45 = nnnn

macro should insert the header in between a24 and a25...and so on...

Please help. I hope i have explained it clealy. Thank you for your time.

Maybe this will help. I've assumed that the bottom row won't always be 200 and is dynamically determined in the code.

Please Login or Register  to view this content.