Hello and thanks for future help, cheers
I need to identify (the location) of a cell in a workbook (with many sheets) from a stated word. For example, does Adams appear in any place within the 6 worksheets?
This formula will take in Names from Adams to Zeraffa (200+ names), which could appear in all the 10 worksheets in a workbook.
Solved by B. A. in 26 mins