Combining two similar worksheets and showing changes

[Guest]

I thought i posted this question yesterday, obviously i have no idea what im
doing, because now i can't find it. But anyway, In excel I have two very
similar worksheets that started out as the same worksheet. They were copied
by someone and now two users have been making changes to them, and i guess
its my job to put them back together, and show the changes that both of the
users made. if i just copied one to the other i would have nearly five
thousand rows of duplicate data. How can i do this? It seems like it would
be so simple, I just don't work with excel that much. these sheets are in
different workbooks, but the workbooks are not shared. Please help a
confused lost little office 2003 user get to the other side of the road!

 

[Max]

Just some thoughts ..

.. its my job to put them back together,
and show the changes that both of the users made.

Try this response to a similar query:
http://tinyurl.com/jlx2e

The sample construct provided in the thread
is still available at:
http://www.savefile.com/files/6790732
Compare_Two_Lists_ClairView_gen.xls

---

 

[Guest]

That did the trick, thank you so much and i really appreciate your time.

 

[Max]

Great to hear it worked for you !
Thanks for the feedback ..