Hi, I need a help.
In the attached file, in sheet1 column A data is given, which is came from sheet2 and there are boxes contain 2 consecutive cell (like A5+A6, A7+A8, A9+A10). If the data is same in consecutive boxes then the boxes will have to 'Merge & Center' and have to show the value.
Thanks in advance for your time.
-------------------------------------------------------------------------------------------
Thread moved to VBA forum
In the attached file, in sheet1 column A data is given, which is came from sheet2 and there are boxes contain 2 consecutive cell (like A5+A6, A7+A8, A9+A10). If the data is same in consecutive boxes then the boxes will have to 'Merge & Center' and have to show the value.
Thanks in advance for your time.
-------------------------------------------------------------------------------------------
Thread moved to VBA forum
Attachments
Last edited by a moderator: