ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   help with mini menus (https://www.excelbanter.com/excel-discussion-misc-queries/105818-help-mini-menus.html)

razorsharpe

help with mini menus
 

Hello,

I have a list which creates a drop down menu. If an item is selected
from the list, I want the next adjacent cell to have a mini menu with a
breakdown of the left cell.

Cell C3 = Hardware

Hardware_List = {AA:1,AA:10}
AA1-10 = Hardware Supplies
= Hardware Costs
...etc.

Is there a conditional listing feature?
thanks in advance,
John


--
razorsharpe
------------------------------------------------------------------------
razorsharpe's Profile: http://www.excelforum.com/member.php...o&userid=34336
View this thread: http://www.excelforum.com/showthread...hreadid=573160


Bob Phillips

help with mini menus
 
If I understand correctly

See http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"razorsharpe"
wrote in message
...

Hello,

I have a list which creates a drop down menu. If an item is selected
from the list, I want the next adjacent cell to have a mini menu with a
breakdown of the left cell.

Cell C3 = Hardware

Hardware_List = {AA:1,AA:10}
AA1-10 = Hardware Supplies
= Hardware Costs
..etc.

Is there a conditional listing feature?
thanks in advance,
John


--
razorsharpe
------------------------------------------------------------------------
razorsharpe's Profile:

http://www.excelforum.com/member.php...o&userid=34336
View this thread: http://www.excelforum.com/showthread...hreadid=573160




razorsharpe

help with mini menus
 

Thanks for the assistance.


--
razorsharpe
------------------------------------------------------------------------
razorsharpe's Profile: http://www.excelforum.com/member.php...o&userid=34336
View this thread: http://www.excelforum.com/showthread...hreadid=573160



All times are GMT +1. The time now is 02:39 AM.

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