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

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.
 
N

NoodNutt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top