How do I summarize items chosen on mulitiple worksheets
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.
|