put dynamic info into comments

N

nlehman02

On my main sheet I have a column that shows different departments (A
and another column that shows the number of employees (B) in tha
department. The number of employees is found from the main list o
employees found on another sheet in the workbook. I was wondering i
there was anyway to show the names of the employees referenced from th
second sheet in a pop-up box of some sort whenever the numbe
cell(B1:Bx) is selected.

Any help appreciated.

Natha
 
F

Frank Kabel

Hi
not possible with comments. this would require an event macro (e.g.
selection change)
 
Top