Sort 2 lists - one w/ last, first name // one w/ first, last name
 

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

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

Insert a column to the right of the names without middle initials. hi-lite
the column of names, go to Data/Test to Columns.... Choose delimited and
space as your delimiter. That will put the first & last names in two
different columns. You can then sort by either first or last name.
Hope that helps.
Darcie

"musicgirl" wrote:

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

THAT HELPED SO MUCH!!!! THANK YOU!!!

"o1darcie1o" wrote:

Insert a column to the right of the names without middle initials. hi-lite
the column of names, go to Data/Test to Columns.... Choose delimited and
space as your delimiter. That will put the first & last names in two
different columns. You can then sort by either first or last name.
Hope that helps.
Darcie

"musicgirl" wrote:

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