I am not very familiar with VBA. However my boss has decided that I need to be. I am trying to create a macro that will highlight/color cells containing key words and then show that data separately in another sheet. So for example, if the word redo is found, it colors the corresponding cells on the original sheet, then copies the entire row that cell is found in and moves it to a new sheet.
The original report that I am trying to filter/sort is about a thousand plus rows. So I want to be able to locate buzzwords, and then move that data to a separate place to be examined more carefully.
I hope that I am explaining this clearly enough. I am hoping someone can point me in the right direction.