I have a workbook that has merged cells in it.



How do I unmerge all the merge cells in that workbook and fill those unmerged cells with the value its parent merge cell had in a different workbook in the same location using VBA.

I know to unmerge all cells in sheet I can use:

But how to do the rest?
To better understand I have attached the merged file & unmerged file(final output file).

Please help.

Attached Files

	merged DATA.xlsx (8.9 KB, 8 views)
	unmerged DATA.xlsx (8.9 KB, 8 views)