How do I create a drop down list that fills multiple cells?

  • Thread starter Thread starter Shawn O
  • Start date Start date
S

Shawn O

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.
 
G'day Shawn

I have a file that may help you.

Drop me a line @ (e-mail address removed) and I will send it to you.

HTH

Regards
Mark.
 
Back
Top