Macro to compare and delete rows
Solved/Closed
Related:
- Macro to compare and delete rows
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to delete whatsapp contact not in address book - Guide
- Compare two excel sheets and highlight differences macro ✓ - Excel Forum
- Delete fake facebook account within 24 hours ✓ - Facebook Forum
- How to delete whatsapp account without phone - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 21, 2010 at 09:15 AM
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