View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shawn O Shawn O is offline
external usenet poster
 
Posts: 1
Default How do I create a drop down list that fills multiple cells?

I am currently working on a standard form in excel to be used as a shipping
document. I have been able to use the drop down lists for names and shipping
addresses with no problems. I have three columns set-up to input up to three
different kinds of track turnouts. I have a list of track material in rows
going down next to the three columns. My question is can I set-up a drop down
list in the three columns that will input numbers unique to the track turnout
which will populate multiple cells to indicate how much of each material to
ship? I have microsoft windows xp 2007. Thanks.