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

Example.xlsx (10.7 KB, 6 views)

Please post in the VBA forum. Ask a mod to move your thread - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

How to move it to the VBA forum? Please advise.

Read my post

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Duplicate thread. Please don't post the same question in multiple locations. Thread closed.

Pecoflyer: Please don't suggest posting in a different forum just because it might be in the wrong one. Mods like me monitor the forums and will move threads if we think it appropriate.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]