Results 1 to 2 of 2

Thread: Excel Summary Sheet

  1. #1

    Excel Summary Sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I need help with a summary sheet setup please.
    For work we use an excel order form that our clients use to order stock. Currently there are 5 sheet tabs with stock available for ordering. It is set up so all the client has to do is enter the quantity of the item that they want. In some cases if they are ordering a personalized product they are required to enter a phone number. There is also a section for them to leave notes.
    What I would like to create is a summary page which only collects information from cells when a client enters a value, so that the summary page only shows what has been ordered.

    example:
    ITEM CODE: DESCRIPTION: SIZE:QTY:
    2001: OUTDOOR T-SHIRT: XS: 2
    2002: OUTDOOR T-SHIRT: M
    2003: OUTDOOR T-SHIRT: L
    2004: OUTDOOR T-SHIRT: XL
    2005: OUTDOOR T-SHIRT: XXL:1
    2006: OUTDOOR T-SHIRT: 3XL


    Using the above example, the client has entered quantities for item code's 2001 and 2005 so I want the summary page to only extract and show the rows for these two items.

    Is this possible?

    Thank you in advance

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    That's possible. Probably best you upload a sample worksheet, so that someone can take a look and get you started.

Posting Permissions

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