Combine of two identical cells and deletion of one cell from the duplication cell.

[waqar1239]

Hi All,

I am in the learning stage of excel macros and trying to create a macro for one of my data sheet.
I tried to create a macro. In which I am trying to compare value of cell B1 with B2. If both equals that cell H1 = combine of cell G1&G2.
and then delete the duplicate row which is row of B2.
Can some one help me in this.
Please my attached file with the email.

Thanks,Waqar

[Kaper]

Hi, you've used i as a loop variable and R in the concatenation instruction.
Try:

Please Login or Register  to view this content.

ps. it will work the same way if you do not refer to cells

Please Login or Register  to view this content.

[waqar1239]

Hi All thanks for your support. I done this.

[waqar1239]

Thanks a lot Kaper.