I have created a excel sheet, where it checks a cell for few conditions in Sheet1 and fill another cell on Sheet2, if the condition is satisfied. If the condition is not satisfied the cell in Sheet2 will be left blank. Above part works fine.

But my requirement is, if there are any merged cells in Sheet1, then it has to automatically merge cells in Sheet2. Is there any possibility to do this.?

Thanks in advance.