Hi!
I have multiple sheets of data moved over from a PDF file. I need to delete rows which contain specific words across all sheets in one go. Is there a way to do this?
As of now I'm using the find all feature-> select all-> delete sheet rows features for each of these words. This takes a long long time for 10 different words across 5 sheet.
All the words are in column A of the sheets.
Appreciate the help in advance!
I have multiple sheets of data moved over from a PDF file. I need to delete rows which contain specific words across all sheets in one go. Is there a way to do this?
As of now I'm using the find all feature-> select all-> delete sheet rows features for each of these words. This takes a long long time for 10 different words across 5 sheet.
All the words are in column A of the sheets.
Appreciate the help in advance!