Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2011
    Posts
    7

    Unanswered: Help with a pop up window with relevant information upon clicking a value in cell

    Hi,

    I have a dashboard with 3 columns as depicted below, where year means the period referred to, Newbees are the new agencies and Existing are the already existing agencies.

    Year Newbee Existing
    2010-11 2.12 163.43
    2011-12 7.92 206.04
    2012-13 11.83 236.19
    2013-14 16.95 237.90

    What I want to do is that when I click on cell A2 (2010-11) or cell A3 (2011-12) or so on, it opens a pop up or a window and displays the names of the agencies in the popup as displayed below:

    2010-11 (Period referring to)
    Sl. No. Newbee Existing
    1 Amit assoc. Gupta & co
    2 Parth co. Aggarwal Logistics
    3 Glennfier The Company
    4 Bumbble ABC & Co
    5 XYZ assoc
    6 hfuh pvt ltd
    7 Mhfnd & co.

    This information will be pulled form a source sheet in the same workbook which will have the period wise breakup of the Newbees and Existing agencies.
    I have attached an example file as well.
    Please help as this is really urgent and with your help I might be able to close it and share this dashboard with my COO today itself.

    Regards

    Prayank
    Attached Files Attached Files
    Last edited by Prayank; 05-15-14 at 02:42.

Posting Permissions

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