Macro to compare and delete rows
Solved/Closed
Related:
- Macro to compare and delete rows
- How to delete whatsapp account without login - Guide
- How to delete a row in a table in word - Guide
- Beyond compare - Download - File management
- How to delete whatsapp account without phone - Guide
- How to delete icloud tabs - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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