Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dbsudy
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
dbsudy
 
Posts: n/a
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a Link Mid-way Across Worksheets Frosty Excel Worksheet Functions 0 August 25th 05 12:03 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 1 March 4th 05 05:42 AM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 0 March 4th 05 04:27 AM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 0 March 4th 05 04:27 AM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"