Balajibenz
Board Regular
- Joined
- Nov 18, 2020
- Messages
- 80
- Office Version
- 2013
- Platform
- Windows
Hi Everyone, can someone help me with below requirement.
I have this sheet1 in wk1 where there are cells that are merged and there might be 5 cells merged or 4 or 3 or 2.
What I am looking for is to create a copy for this sheet and unmerge all the merged cells and while undergoing if there is some text and color present in the merged cell then it should be copied to each cell that has been unmerged from that particular merge.
Thanks in advance.
I have this sheet1 in wk1 where there are cells that are merged and there might be 5 cells merged or 4 or 3 or 2.
What I am looking for is to create a copy for this sheet and unmerge all the merged cells and while undergoing if there is some text and color present in the merged cell then it should be copied to each cell that has been unmerged from that particular merge.
Thanks in advance.