Macro to compare and delete rows
Solved/Closed
Related:
- Macro to compare and delete rows
- Macros to Delete Rows in Excel 2007 ✓ - Forum - Programming
- Macro to delete row after certain condition found ✓ - Forum - Excel
- Excel Macro for deleting rows IF cells not... ✓ - Forum - Excel
- Macro to compare two excel sheets ✓ - Forum - Excel
- How to compare two Excel sheets with varying data ✓ - Forum - Excel
1 reply
rizvisa1
May 21, 2010 at 09:15 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
May 21, 2010 at 09:15 AM
The best way would be to have a temp column on sheet 2. In that column you can use a VLOOKUP like this
=IF(ISERROR(VLOOKUP(A1, SHeet1!A:A, 1, false)), 0, 1)
Then apply filter on sheet 2 for 1
Delete all the rows that are filtered
Remove filter
Clear out the temp column
You can record these actions via excel macro recorder and it will give you a macro that you can use later too
=IF(ISERROR(VLOOKUP(A1, SHeet1!A:A, 1, false)), 0, 1)
Then apply filter on sheet 2 for 1
Delete all the rows that are filtered
Remove filter
Clear out the temp column
You can record these actions via excel macro recorder and it will give you a macro that you can use later too
May 21, 2010 at 09:37 AM