Hello. I apologise if this topic has been covered before but I've had a look and cannot find an answer on this forum.
I often spend a lot of time sorting through a large spreadsheet of data and cutting out certain rows I know to be unnecessary based on a word or part of word they contain.
I would be grateful if someone could suggest a method to search through a spready and delete any row contaning a certain string.
For example, if I had:
twotwothree
oneonetwo
twothreeone
onetwotwo
threethreeone
and wanted to get rid of any row containing 'three' to leave just
oneonetwo
onetwotwo
The data I need to search for and remove is always different so it would be ideal to have an input box to prompt for the string to search for, so in the above example for eg. you could specify 'two' instead of 'three'. In addition the data is not always in the same column.
Please help! Going through each and every row rightclick-deleting irrelevant ones is driving me crazy. I've scoured the internet for solutions to this, and I've found various 'solutions' that appear to be ideal, but when I try to use them nothing ever happens (well, one deleted absolutely everything). I have a general idea of coding but no clue about Excel VBA, which makes me all the more frustrated when it looks like something should work but I'm at a loss to work out why it doesn't. I'm using Excel 2003, if that makes any difference at all.
Thanks in advance.
Bookmarks