Re: Creating a single order form from multiple drop down box
Thanks for the reply. To answer your question for more information, I have (7) drop down boxes where each is a separate category. In this particular case, the categories are Glue, Bolts, Screws, Cleaners, Boxes, Blades and Wrenches. Each of the seven individual categories may have as many as 200 items or as little as 10. For example, under the Bolt drop down box I have 200 different types of bolts ranging in sizes and type but in the Glue category I only have two. From the (7) category drop down boxes I may be picking (2) types of glues, (5) types of Cleaners and (15) types of bolts. I would like to go through each of the categories, if needed, and pick the separate items but have them listed on a separate sheet starting at A1 and continuing down the A column until my 'order' is finished. I hope to have something that looks like this:
A1 on sheet #2
Glue #1
Glue #2
Cleaner #1
Cleaner #2
Cleaner #3
ETC
All generated from my 7 category drop down boxes located on sheet #1.
Does that help narrow it down?
Thanks