i need vba code for deleting rows in excel based on different sheets data

Hi,

I have data in Sheet1 its contain 8 Columns

I have data in Sheet2, sheet3,sheet4,sheet5 with one column
sheet2 data need to check with sheet1 column A if matching found the row should delete
sheet3 data need to check with sheet1 Column E if matching found the row should delete
sheet4 data need to check with sheet1 Column F if matching found the row should delete
sheet5 data need to check with sheet1 Column H if matching found the row should delete

I have done for sheet2 data

the code is

Please Login or Register  to view this content.