+ Reply to Thread
Results 1 to 2 of 2

Display Cell Reference of other worksheets with a particular word.

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    London
    MS-Off Ver
    Several
    Posts
    3

    Display Cell Reference of other worksheets with a particular word.

    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

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Display Cell Reference of other worksheets with a particular word.

    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.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Display All results from word list that appear in cell
    By sam103329 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-22-2013, 02:47 PM
  2. [SOLVED] how to search for a spesific word with in a cell and display in the next cell (HELP!!!!)
    By singer.joseph in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-27-2013, 05:30 AM
  3. Replies: 13
    Last Post: 08-04-2011, 09:41 AM
  4. Display data reference from another worksheet based on cell reference
    By Drew123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2011, 03:52 PM
  5. Get cell to display a specific word
    By jsolder in forum Excel General
    Replies: 3
    Last Post: 10-23-2009, 06:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1