ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing Two Worksheets for changes (https://www.excelbanter.com/excel-discussion-misc-queries/59265-comparing-two-worksheets-changes.html)

Jugglertwo

Comparing Two Worksheets for changes
 
Here is the problem: I have two people on a committee that work at two
different companies. They each need to work on a list of attendees for a
future technology conference. Some information will be changed for the
various attendees and some new attendees will be added. With "Mary" and
"Betty" each working on her list it becomes difficult to maintain an updated
and current list with all the attendee information.
If they were on the same network, they both could access the original file
and all changes would be to the original. Howver, they are not on the same
network.
"Mary" and "Betty" are very frustrated because they are losing changes and
really don't know the best way to proceed with their situation. I know Excel
fairly well so they have come to me.
I'm not sure what to tell them.
I'm not sure if it really is an Excel question that has an Excel solution or
perhaps it is more a network solution. Network meaning perhaps there is a
free site out on the net that would allow them to have the original file live
there and they could both access it. I don't know of such a free site.
Any suggestions would be greatly appreciated !
Thanks!
Jugglertwo

Jerry Price

Comparing Two Worksheets for changes
 
Since they work at different companies, sharing workbooks within Excel
is probably out.

This might help though. Not sure if this an option or not for you.


=== http://office.microsoft.com/en-us/as...843681033.aspx




Jugglertwo wrote:

Here is the problem: I have two people on a committee that work at two
different companies. They each need to work on a list of attendees for a
future technology conference. Some information will be changed for the
various attendees and some new attendees will be added. With "Mary" and
"Betty" each working on her list it becomes difficult to maintain an updated
and current list with all the attendee information.
If they were on the same network, they both could access the original file
and all changes would be to the original. Howver, they are not on the same
network.
"Mary" and "Betty" are very frustrated because they are losing changes and
really don't know the best way to proceed with their situation. I know Excel
fairly well so they have come to me.
I'm not sure what to tell them.
I'm not sure if it really is an Excel question that has an Excel solution or
perhaps it is more a network solution. Network meaning perhaps there is a
free site out on the net that would allow them to have the original file live
there and they could both access it. I don't know of such a free site.
Any suggestions would be greatly appreciated !
Thanks!
Jugglertwo


--
Thanks & Regards,

Jerry


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com