I just came across a bit of a challenge in a project I've been working on for
weeks. I have a pivot solution for a process where operators take
information on calls (repair jobs), and then statistics on how many calls of
what type, etc. Problem is I did not foresee the issue of two operators,
managing two separate lists, and then needing to update them.

The way it works is as follows:

1) two operators take calls (assume brand new start so day 1 is all new calls)
2) end of day, the lists get merged and then parsed out by mechanic's name
(to whom the job is assigned
3) next day, new jobs come in, but they also get updates on previous days'
jobs, which they currently put directly into those mechanics' sheets
4) they then append the new jobs from the day to the mechanic sheets, and so
the process continues.

In the above, I can get the pivot to parse out an initial set of data into
separate files (pages with the mechanics names on different files and sheet
tabs). But as far as updating the records, my problem is that there are two
source files which, everyday need to be merged. The new records are easy,
with the one main copy getting the new records from the other main copy (and
so the pivot updates with a larger list). But during the day with updates to
old jobs, there is not one operator who handles all updates, and the operator
that originally took the call (and therefore has the original record) is not
necessarily the one that takes the update. So the problem is that I don't
know how, at the end of the day, to easily merge the two files' records to
where Excel can basically look at two files and know what was changed in
each, using that knowledge to make the change in the counterpart.

If any of that makes sense and someone is very creative here, please help.
I am on a deadline for this and just came across this disastrous realization.
--
Boris