Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Information
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?!? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Information
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 -- Regards, Tom Ogilvy mkresch wrote in message ... 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?!? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Information
If your data is arranged as a table with headings, with the employee
name entered in each row, you can use an AutoFilter (DataFilterAutoFilter) 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 he http://www.contextures.com/xlautofilter01.html mkresch wrote: 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?!? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Information
You could write an event to hide specific rows when the cell is clicked.
Shockley "mkresch" wrote in message ... 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?!? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Information
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. "shockley" wrote in message ... You could write an event to hide specific rows when the cell is clicked. Shockley "mkresch" wrote in message ... 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?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a drop down which causes information to appear. | Excel Worksheet Functions | |||
Showing information according to a selection in a drop down box | Excel Worksheet Functions | |||
Drop down need to validate information | Excel Discussion (Misc queries) | |||
Missing information in autofilter drop down Excel 97 | Excel Discussion (Misc queries) | |||
how do I create a drop down list that assigns certain information | Excel Discussion (Misc queries) |