Drop Down List

[Judd Smith]

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

 

[Judd Smith]

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]

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]

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]

Why would you have to have the list in multiple columns?

 

[royUK]

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