ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Drop Down Menu to display a field of data (https://www.excelbanter.com/excel-worksheet-functions/164119-drop-down-menu-display-field-data.html)

[email protected][_2_]

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?


Gary[_2_]

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?





All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com