Combining two similar worksheets and showing changes
 

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!
--
dbsudy

Combining two similar worksheets and showing changes
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbsudy" wrote in message
...
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!
--
dbsudy

Combining two similar worksheets and showing changes
 

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


"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbsudy" wrote in message
...
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!
--
dbsudy

Combining two similar worksheets and showing changes
 

Great to hear it worked for you !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbsudy" wrote in message
...
That did the trick, thank you so much and i really appreciate your time.
--
dbsudy