One way is to paste one under the other, then sort them, then remove duplicates, if
necessary (there's stuff to remove dups at www.cpearson.com).

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"GKW in GA" wrote in message
...
I have 2 .xls files that are fomatted exactly the same File1 contains some
rows that are not in File2 and vice versa. Each File has 4 columns. How can I
get the rows that exist in File2 that are not in File1 into File1 and the
rows in File1 that are not in File2 into File2 so both documetns contain
exactly the same thing