Drop Down List

Judd Smith

New Member
Joined
Oct 25, 2002
Messages
17
List is one sheet of book and drop down list is repeated on 15 lines of another sheet. The purpose is to create a menu for food service biz, by selecting menu items from a drop down list. The menu will have 15 or more items, so the drop down list will need to be repeated 15+ times
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Judd Smith

New Member
Joined
Oct 25, 2002
Messages
17
On 2002-10-26 15:50, Judd Smith wrote:
List is one sheet of book and drop down list is repeated on 15 lines of another sheet. The purpose is to create a menu for food service biz, by selecting menu items from a drop down list. The menu will have 15 or more items, so the drop down list will need to be repeated 15+ times
 

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
Judd,

If it's a drop down list via Data Validation,then
highlight your menu items in say column A1:A15 and name the range, either by using the small window above column A or by using Insert/Name/Define.

In the other worksheet, highlight the cells you want the list to display, the go to Data/Validation/ in the allow window, select list and in the source window enter =menu(or whatever you named your list), click OK
 

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
Judd PM'd me with this question:

But - what if I want to have a drop down list referring to more that one column in the other sheet. Trying the above steps will not work with multiple columns.

Anyone have any other ideas?
 

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
Why would you have to have the list in multiple columns?
 

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
Are you trying to have dropdown list to bring items from one column and prices from another? If so use your drop down list to pick the item and Lookup or Vlookup to add the price based on the choice from your dropdown list
 

Forum statistics

Threads
1,143,752
Messages
5,720,637
Members
422,295
Latest member
Ryamker3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top