Drop Down Information

  • Thread starter Thread starter mkresch
  • Start date Start date
M

mkresch

I have a director who wants to be able to click on an
employee's name and have there hr information drop down
from there. I've entered all the data into a
spreadsheet. However, he doesn't want to see all the
data at one time. He wants to be able to click on an
employee name and view chart string info, pay info, etc.
Some individuals are paid from several sources and should
have multiple drop down rows. I'm not sure how to set
this up with excel. Can anyone help?!?
 
how about using a Pivot Table and use the employee name as a pagefield.

Assumes the data that you are looking at is arranged as a database
 
If your data is arranged as a table with headings, with the employee
name entered in each row, you can use an AutoFilter
(Data>Filter>AutoFilter) to view specific data.

From the dropdown list in the heading of the Employee name column,
select any name, and you'll see only that data.

There's some information here:

http://www.contextures.com/xlautofilter01.html
 
Change that to show specific rows when the cell is clicked. You would also
need a toolbar (or other control) to hide the rows again.
 
Back
Top