View Single Post
  #1   Report Post  
HR Guy
 
Posts: n/a
Default Finding duplicate records in multiple worksheets

Each month I run a employee FT/PT status vs avg hrs worked exception report
which is exported to Excel. I manually flag repeat occurances (employee on
the report 3 mos, etc.). I would like to run a query which would compare up
to 12 monthly worksheets and count the number of times an employee was on the
monthly reports. This count would be part of the new monthly report each
month.