parscon
11-20-2012, 01:33 PM
Dear Friend ,
I need your helps ,
I have excel file that have 2 sheet . 1 sheet have one column A and another sheet have some other data
I want to check sheet2 if find any data of sheet1 on column A in any column of sheet2 delete the row of that sheet(sheet2)
for example if I have number 2243232 in column A of sheet1 and also I have the same data in sheet 2 but in column J of row 420 , delete the row 420.
(if find he same data in any column of that row delete that row on sheet2)
Hope you understand what I need .
I need your helps ,
I have excel file that have 2 sheet . 1 sheet have one column A and another sheet have some other data
I want to check sheet2 if find any data of sheet1 on column A in any column of sheet2 delete the row of that sheet(sheet2)
for example if I have number 2243232 in column A of sheet1 and also I have the same data in sheet 2 but in column J of row 420 , delete the row 420.
(if find he same data in any column of that row delete that row on sheet2)
Hope you understand what I need .