y dont u try with SORT, it can be done and doesn;t seem to that difficult.
Provide with the file ora good example in a more explanatory way

--
Hope it Helps!
Jim
India




"musicgirl" wrote in message
...
I have 2 very large excel files that have pulled employee name, week
ending
and hours information. The information comes from 2 different systems.
As a
result, the names are not input the same way. I need to combine both
lists
and make sure that they mirror one another. Is that possible using a
macro
or sorting by "matching"?
Ex. AGARWAL NIMISH, 10/1/2004, 20 hours // NIMISH R AGARWAL,10/1/2004, 20
hours