View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Anders Silven Anders Silven is offline
external usenet poster
 
Posts: 25
Default drop downlist that captures criteria from another sheet

Using a named list, you can have the list on another sheet.

There are some good instructions (and more) he

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

HTH
Anders Silven

As far as using a list from another sheet i have tried to do this and
you cant