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
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
