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.

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

G'day Shawn

I have a file that may help you.

Drop me a line @ and I will send it to you.

HTH

Regards
Mark.