+ Reply to Thread
Results 1 to 1 of 1

Hyperlinked Index with additional info from referenced cells???

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Hyperlinked Index with additional info from referenced cells???

    I wonder if any of you might help?

    I am performing costings of products and would like to have a summary sheet listing all products by Number, Name and Cost Price.
    The Worksheets are named "1234-Product name".
    I’d like this index list to be populated automatically so I have taken the following steps:
    Each product has it’s own worksheet and the data I wish to show is ALWAYS in the same cells C3, C4 & C5.
    I can get an Index list via a macro but this only shows the name of each worksheet hyperlinked (which happens to be the product name). This is a good start, but I would like the list to automatically be populated by the accompanying product number and price by referencing the relevant cells on each worksheet automatically so I can just duplicate a template costing page and have an index populate itself with name, number and cost.
    I have attached a screenshot of my template page with the detail I wish to show in the Index page.

    Hope this makes some sense and that you may be able to help.
    Best Regards,
    Andrew
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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