parscon
02-25-2014, 01:50 PM
I need a VBA code that check column A and B and if find the same data as you see in the below images combine and merge them in one row in sheet 2 and delete the rows that combined in sheet1
Sheet1 : Before Run VBA
http://i59.tinypic.com/qrlkyx.png
Sheet2 : After run VBA
http://i59.tinypic.com/zindrp.png
Sheet1 : when deleted the data on sheet1
http://i58.tinypic.com/11ju03m.png
Thank you very much.
Sheet1 : Before Run VBA
http://i59.tinypic.com/qrlkyx.png
Sheet2 : After run VBA
http://i59.tinypic.com/zindrp.png
Sheet1 : when deleted the data on sheet1
http://i58.tinypic.com/11ju03m.png
Thank you very much.