Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently have this existing code that checks to if the value is the
same between col E and P and if true, the row is deleted. 'lastrow = Cells(Rows.Count, 4).End(xlUp).Row 'For i = lastrow To 1 Step -1 ' If Cells(i, "E").Value = Cells(i, "P").Value Then ' Rows(i).Delete 'End If 'Next How can I change this to compare values between col A in worksheet 1 and col A in worksheet 2, and if the value is the same, delete that row in worksheet 1? Thank you, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Rows and delete duplicate records | Excel Worksheet Functions | |||
Help! -How to compare two worksheets; multiple rows of data=result | Excel Worksheet Functions | |||
Compare 1st 8 digits of rows in three worksheets | Excel Worksheet Functions | |||
Add or Delete Rows in Protected worksheets | Excel Discussion (Misc queries) | |||
Using VBA to delete certain worksheets rows | Excel Programming |