View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdshon cdshon is offline
external usenet poster
 
Posts: 1
Default summarize data from multiple worksheets

I have a workbook with 33 sheets representing 33 pay periods. I have a list
of 3900 employees who were paid during the year. How can I summarize the
data by employee to get a total for the year? Not every employee was paid
every pay date.