Hi

I need a function that will mirror the main tab that contains merged cells but shows the merged range as unmerged with the data drom the merged present.

Its hard to explain so i have uploaded a Doc with a demo of what i need. I have also put a Macro in there that may be modified to a function?

The Main tab needs to stay untouched.

Thanks

Rob

Merge to mirror.xlsm