excel order form RRS feed

  • Question

  • I have an order form that I create but it is too lengthy when it is printed out. Everything on the list prints out including the items not ordered. I want to be able to do the following. This order form contains warehouse supplies used for shipping purposes. There are over 50 items on this list however we do not always order everything on this list so if I can create a formula that will only display the item ordered when a value is entered.

    Description ,                  PRODUCT CODE  , On Hand Inventory , required,  Qty to Order
    1/2" METAL STRAPS          #12345                                 4                       10                   6

    I would like to create an "OK" command button. If a value is entered in the onhand inventory column I would click "OK" and this form will open in another window only displaying that items that was selected. Also I would like to have an option to print.

    Can anyone help???


    Thursday, February 12, 2009 3:01 PM