I have an excel that has information all over the place. I need to be able to sort through almost 5,000 rows and multiple columns for specific words. I need a macro that can search the entire sheet, and not just a column or a row. I keep finding macros that search a specific column for the word > copy the row > paste to a new sheet....... Is there a way to search all cells for a specific word > cut row> move rows up> paste row into another sheet? Main thing being search all cells, because the information that i''m looking for isn't in the same column every time.
Bookmarks