I need to create a macro that will do a find based on a a cell in another sheet. When it finds this word on the sheet, it will do a loop to see how many of these words in the column and it will select them. This word is usually in column B. It needs to select everything that is in column A, B, C and D in the case where the word is the same in Column B.
The data will already be sorted. Thanks.