Hi,
I'm trying to create one macro that would automate a simple, but time consuming task, of 1)searching a column for up to 4 key words, 2)highlighting cells "yellow" in that column which contain the key word(s), 3)changing text color of found key word(s) to "red", and 4)filtering the colum by the highlighted cell color.
It would be ideal if a MsgBoxInputBox would allow the user to enter the key words. Similar to the existing Find and Replace, but allowing more than one search criteria. The magic happens followed by a MsgBox that tells the user how many unique rows were found.
Any help is greatly appreciated. Thanks!
I'm trying to create one macro that would automate a simple, but time consuming task, of 1)searching a column for up to 4 key words, 2)highlighting cells "yellow" in that column which contain the key word(s), 3)changing text color of found key word(s) to "red", and 4)filtering the colum by the highlighted cell color.
It would be ideal if a MsgBoxInputBox would allow the user to enter the key words. Similar to the existing Find and Replace, but allowing more than one search criteria. The magic happens followed by a MsgBox that tells the user how many unique rows were found.
Any help is greatly appreciated. Thanks!
