PDA

View Full Version : Check 2 column and Combine Data



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.