Select a range of cells to cpy based on a text searh
Hello to the wise and learned folks at the excel forum. So I have attached a sample spreadshet to illustrate what I want to do. The actual spreadsheet I am working on is much larger than this one. As you can see, I have a worksheet with a cell range of A1 to F4. What I wish to do is find a formula that will allow me to select every row that has the text"SAFEWAY" in it, I would prefer the search is not case sensitive. Then after finding all the matches, I want to have excel automatically select not only those cells, but the entire row that cntains this text. In my example all of the matches to "SAFEWAY" are in columns E and F, but in my larger spreadsheet, the match could be in any column. I want any cell that matches "SAFEWAY" or "safeway" to be selected, along wih the entire row that the cell is in, as hilighted in red on my sample spreadsheet. Thanks for your help
|