|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with a pop up window with relevant information upon clicking a value in cell | Pvidya | Excel | 4 | 05-15-2014 04:58 PM |
Cells highlighting when clicking on them? | Tom0822 | Excel | 1 | 02-05-2013 11:59 AM |
Hyperlink clicking setting? | Thomas G Fields III | Outlook | 4 | 10-30-2012 07:36 AM |
'Linking' entered information to other "cells" from an original "cell" in MS Word | Wade | Word | 6 | 09-03-2012 05:22 PM |
How to relevant task to a folder | yoni | Outlook | 1 | 01-02-2012 12:29 AM |