Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu to display a field of data
I'm trying to create a drop down menu full of items. Once an item is
selected from this menu, all of the item's corresponding data is displayed. The item's data would be for example a field such as "A27:T27" and I want the entire field displayed. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu to display a field of data
I guess you can use List option under validation and then use VLOOKUP to
display the other data. I can get into details if you give me some more information. Thanks wrote in message oups.com... I'm trying to create a drop down menu full of items. Once an item is selected from this menu, all of the item's corresponding data is displayed. The item's data would be for example a field such as "A27:T27" and I want the entire field displayed. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you format data that is part of a drop down menu? | Excel Discussion (Misc queries) | |||
The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
help with drop down menu data | Excel Discussion (Misc queries) | |||
Filtering Data with a Drop Down field | Excel Worksheet Functions |