theora
New Member
- Joined
- Jul 17, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi,
I need a macro to highlight rows where the cell in column N contains any one of a list of words. I tried using Advance Filter but I couldn't get it to work. Column N contains notes so I want to find specific text strings in each cell.
So for example cell N3 contains "Please modify the Network User ID for the following Customer". I want to highlight the whole row if it contains any of the words customer, workstation, windows, account etc.
I actually need to delete those rows but my spreadsheets contain anything up to 10,000 rows and I need to search for about 20 different text strings so I figured it would be faster to highlight all those rows and then filter on the highlight and delete them all at once instead of trying to use the one macro to both find and delete the rows.
Hope I've explained it well enough.
Leigh
I need a macro to highlight rows where the cell in column N contains any one of a list of words. I tried using Advance Filter but I couldn't get it to work. Column N contains notes so I want to find specific text strings in each cell.
So for example cell N3 contains "Please modify the Network User ID for the following Customer". I want to highlight the whole row if it contains any of the words customer, workstation, windows, account etc.
I actually need to delete those rows but my spreadsheets contain anything up to 10,000 rows and I need to search for about 20 different text strings so I figured it would be faster to highlight all those rows and then filter on the highlight and delete them all at once instead of trying to use the one macro to both find and delete the rows.
Hope I've explained it well enough.
Leigh