How do I summarize items chosen on mulitiple worksheets

S

Sunshine

I have an Excel file that has multiple worksheets that outline different
products for people to order. They choose which items they want by
indicating quantity. I would like to find a way to have a summary page that
outlines all items that have a quantity marked on it, with the description,
so that items are not missed. Currently , we have to check each worksheet
and sometimes items are missed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to summarize copied data 2
Summary of Unique item values 2
Can I pull Data from a list by store # and quantity 0
I want to copy rows with values >0 to another worksheet automatica 4
Conditional auto-filtering to summarize data 1
is this possible in excel 2007 3
Combining worksheets with common column but different number of ro 3
How can I pull Cell value from Detail worksheet into Summary sheet? 2

Top