Return position for each matching value in entire workbook?
Is there a function or command for a cell in a worksheet that results in a
search of the entire Excel workbook and which then returns (in the worksheet)
the full value / content of each cell in the workbook that matches the
criteria of the search. For example, on one worksheet I want to see every
cell (in its entirety) of the workbook that contains a particular number or
phrase.
|