Results 1 to 5 of 5

Hello & Need help pulling data from 3 sheets into 1 sheet via onClick function.

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Hello & Need help pulling data from 3 sheets into 1 sheet via onClick function.

    Hi Everyone.

    I'm looking to try to put some sanity in a bunch off information and make it easier for our field team to find informaiton. We have a bunch of dev kits with various parts and the related software and required documentation etc. Problem is when a customer calls they give us a part number and there isn't a lookup of what's all in the kit and what documents we should send.

    I've created the attached and am looking to use the Chip page as an index. From there if you click the chip name say "2345" it would show you a detailed listing pulled from the attached sheets.
    ie all the sub components on the parts page along with all the documents and SW etc needed so that when we support a customer everything we need to know they have or need is on one page. so pull from three tabs and display the information either on a pop up or a new temporary tab.

    Hopefully I've described what I want ok. It would be nice to have a onClick function that would grab the information and populate a window. I can't seem to find any onClick function in excel 2007 however.
    Attached Files Attached Files
    Last edited by bf01; 08-13-2012 at 03:39 PM. Reason: Update Title

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