+ Reply to Thread
Results 1 to 4 of 4

Dynamic Order Form

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Dynamic Order Form

    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.


    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,930

    Re: Dynamic Order Form

    One simple way would be to use a helper column. See attached for what I think you mean.

    BSB.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Dynamic Order Form

    This is seems to be exactly what I was looking for. A helper column, that I can then hide, is something I would have never thought of to do. Very clever!

    I would love to understand a little better what is going on within the INDEX-MATCH formula here. I understand the need to use COUNTIF function as it reminds me of using a ++ operator in C++. The IFERROR will return the reference INDEX or nothing, which would leave anything above what the Helper Column has counted to blank. This is where I am a little thrown "MATCH(ROWS($1:1),". I think I understand it as a whole but I am confused by it in pieces. This is to check what item is in the row once the helper counter has gone up in value, correct?

    Thanks Very Much

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Dynamic Order Form

    Or maybe you interested in without helper column? please seee the file

    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Order Form
    By sharma4845 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2013, 05:53 PM
  2. Order Form
    By Bsm21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2010, 08:18 PM
  3. Need help with an order form
    By abledsoe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2010, 09:19 AM
  4. Order form to BOL?
    By jpletting in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-12-2005, 09:35 AM
  5. Order Form
    By Scott MacLellan in forum Excel General
    Replies: 1
    Last Post: 04-28-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1