+ Reply to Thread
Results 1 to 5 of 5

Using an Automated Index Sheet to summarise a catalogue. Extract text string to define cel

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Aberdeen, UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Using an Automated Index Sheet to summarise a catalogue. Extract text string to define cel

    I have a built a catalogue of records for various of my companies assets. Each asset has its own sheet in a work book and I have used a vb macro to include an automatic Index sheet at the front of the book. This takes the names of the various tabs, in the order I have them in the workbook and creates a simple listing in column A as an Index List

    What I want to do is to build a summary table to the right of the Index List, pulling in a few of the key data points about the assets into a single table.

    To do that I need to be able to extract the text string from the Index List and use it to form part of a cell reference pointing to a specific cell in the relevant individual Asset sheets.

    Any clues?

  2. #2
    Registered User
    Join Date
    06-10-2013
    Location
    Aberdeen, UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Using an Automated Index Sheet to summarise a catalogue. Extract text string to define

    Image attached shows a bit more of what I want to do:

    Picture1.jpg

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Using an Automated Index Sheet to summarise a catalogue. Extract text string to define

    use the below formula
    =INDIRECT(ADDRESS(24,7,,,A2))

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Using an Automated Index Sheet to summarise a catalogue. Extract text string to define

    the below formula also works
    =INDIRECT(A3&"!"&"$G$24")

  5. #5
    Registered User
    Join Date
    06-10-2013
    Location
    Aberdeen, UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Smile Re: Using an Automated Index Sheet to summarise a catalogue. Extract text string to define

    Great, that's perfect!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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