View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Default value in Drop down menu and automatic selections

G'day Body

Take a look at Debra Dalgliesh's Website

www.contextures.com

she has a page on multiple cross validation, whereby you can select say a
company in ColumnA which then filters all the names that match that company
in ColumnB, and then viceversa, Select the Name from ColumnB and it will
display the Company in ColumnA.

HTH
Mark.