Excel Summary Sheet

Sandye

New member
Joined
Jul 18, 2013
Messages
1
Reaction score
0
Points
0
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
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
That's possible. Probably best you upload a sample worksheet, so that someone can take a look and get you started.
 
Top