Working in a report writer I needed to extract all active employees as of 5/31/08 but I also needed to capture all rehires and terminations between 6/1/07 to 5/31/08, but could not get this information in one report, hence the two files.
So I have rows of data containing in cell A location, Cell B paygroup, Cell C name, Cell D hire date, Cell E rehire date, Cell F termination date as an example.
I may have myself in both of those files because I was an active employee as of 5/31/08 on the one file and I was a rehire as of 8/1/07 on the other file.
I know I can copy and paste the data from the one file into the other but would like to eliminate any duplicates such as the example provided above.
Although not directly answered, I am guessing that the check needs to be on column C (name) only. Is that correct? In other words, if the same name appears in column C of each file then that is considered a duplicate and should be deleted?