VBA code to search all merged cells and then unmerge them filling them with values

Hi I would like some help on following.

I have a sheet which has various groups of merged cell. Each merged cell has its own different value. Now What I would like to do is unmerge all the cells, and then fill the unmerged cells with the same value. I am uploading an excel workbook which has 2 sheets. One is the raw data that we have and one sheet is the output we need to achieve. Can someone help me do this?

Originally Posted by mikerickson

This should unmerge the cells.
Your RAW example didn't include a 2007 placement date, did you want that added?

Please Login or Register  to view this content.

Oh, first of thank you so much!! this is great I would have never been able to do this on my own. And That 2007 got deleted when i was making this example file. I was just trimming it down to make it lighter. But thanks :D.

Just one more thing if possible, can you add documentation to this code. I am new at this will help me understand it.

Originally Posted by mikerickson

Please Login or Register  to view this content.

Thank you yet again.

Thank you very much for this post

Hello, when I try this exact script i get an error in the line that says
"For Each oneCell In"...

what am I supposed to put after In? I copy pasted what you put directly and it doesn't work, help!!

Thanks in advance!

Awesome ... Thank you so much