View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How do I sum data in worksheet 1 to be placed in worksheet 2?

Sounds like a job for pivot table - from the data menu, pivot table and
then follow the wizard