View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sunshine Sunshine is offline
external usenet poster
 
Posts: 18
Default 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.