Display Cell Reference of other worksheets with a particular word.

[rgthomas90]

Trying to make (what I thought should be quite simple) a spreadsheet with all the separate cell references of the word "Type" in all the worksheets in a file (so eg. Household Number 1, Household Number 3, etc.)

I have been playing around with trying Find, Search, Match - =MATCH("Type", INDIRECT("Household Number "&A2&"'!$C:$C"), 0) - -- this being my last effort.

Any help would be greatly appreciated.

G

[daffodil11]

I'd probably go with a little bit of code.
This short subroutine finds every reference to the word and lists the Sheet Name and cell references in Column A.

You can use this code by hitting Alt+F11 in Excel, go to Insert -> Module, and paste the code there, and close that window.

To call the macro, hit Alt+F8 and choose it from the list. It will ask you for a word to find.

Please Login or Register  to view this content.