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:
Quote:
ActiveSheet.Cells.UnMerge
|
But how to do the rest?
To better understand I have attached the merged file & unmerged file(final output file).
Please help.