How to create an order form with drop down lists that populate multiple cells

Hey all!

Well I'm at a crossroads here trying to figure this one out. Essentially, I've started my own business recently and have been entering orders in manually but unfortunately this causes too many errors. I'd like to create a sales order form that lets me choose from a drop down list a style # and when that style # is selected it automatically fills in the corresponding cells I need it to with other info attached to that style # such as style name, wholesale price, retail price, margin % as well as MY wholesaler margin (but this should be in a hidden cell off to the side of the order form perhaps in cell AB or AC). The color and category cells would have a drop down list of standard choices for every style so this should be pretty straihgtforward.

I know it can be done and I've scoured the net trying to find some idea on how to do this but to no avail. If someone wants to give it a crack and let me know how it's done I'd be very grateful! I've attached a sample order form with some data in another sheet and have done a small example in the order form sheet of what I would like it to do really.

Thanks for reading!

d.

Example Order Form Data.xlsx

Yes, so I guess then each style # with more than 1 style attached to it would need a drop down list too to differentiate which one to use? That would probably be immensely complicated. Probably it's better that I make the STYLE NAME the drop down list and have the style # attached to that?

Originally Posted by FDibbins

looking at your data, i have made some changes, not sure if they will suite your needs or not, but it allows the lookups to work better, and to pull out the info you need. take a look at the attached file and let me know if this will work for you? the data highlighted in yellow can be deleted AFTER you have valued the contents of columns B, D and E

Hey thanks but I don't see a drop down in that file you gave me? Nor do I see any data highlighted in yellow?

ok now that makes sense! I thank you so much for that...it's what I asked for....but now that I'm looking at it I think it would make more sense to do the drop down by style name not by style #...the style # I have to give to my supplier and can't change (example adding an A or B to the end)...is there a simple way I could do that and have the style number (and price, m.u.) attach to it instead? It's just inversing the style name and style #?

Thanks again for your help you've been so wonderful....