LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding DUplicate Data set in Worksheets SAT Excel Worksheet Functions 4 September 17th 05 11:50 PM
Duplicate Worksheets mlofton Excel Discussion (Misc queries) 1 September 7th 05 02:58 PM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Finding Data in multiple worksheets [email protected] Excel Discussion (Misc queries) 1 February 10th 05 10:42 PM
Finding duplicate records in Excel KG Excel Discussion (Misc queries) 2 December 22nd 04 07:44 PM


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"