Dynamic Order Form

[Freeman]

Hi all,

I have been searching for awhile to find a solution to creating an order form like the example attached. I want a user to be able to select how many boxes they want to order and then as they enter quantities the Ordered List will update with the description from the Item to Order list and with the Boxes Ordered. The idea being that this will be a long list that when it is being shipped the person who needs to put together a shipment can just look at the Ordered List instead of scrolling through the entire Items to Order list.

I have tried vlookup but I believe because it stops searching after finding a single result that this won't work.

I tried Index and Match but everything I seemed to try didn't quite work, granted this was new for me.

I looked through quite a few tutorials in using VBA and VB Objects (list box) but couldn't quite figure out out to create a live dynamic list.

Ideally I would like the Ordered List to update as any Boxes Ordered quantity are entered but using a Macro or Advanced Filter is also acceptable. I posted this at another forum as well so I will make sure to update this if a solution is found.


Thanks for any help

 

[Luke M]

Welcome to the forum, Freeman.

Please see the attached as an example using Macro + Adv. Filter.

You could build the list using the formula I describe here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
but since you mentioned it could be a very long list, it might become too calculation intensive. Either way will work, totally up to you.

 

[Freeman]

Thank you Luke

I mentioned that I posted this at another forum and happened to check that one first after work. I did get a pretty clever response that I have attached and I think everyone can benefit if they are looking for something similar. I haven't dug into your tutorial but I plan on it tonight to see which one will better suit my needs.

Thank you again Luke for your quick response

 

[Luke M]

Hi Freeman,

No worries my friend, thanks for coming back and letting us know, and for sharing the solution.