Just came across a bit of a challenge in a project I've been working on for
weeks. I need to keep two lists synched up with their changes. Two files,
both in Excel 2000. Original entries get pasted each day from one file to
the other. Then at the start of the next day, each list is used by two
different people (starting at time 0 with exactly the same data, but then
adding different pieces througout the day AND updating the previous days'
entries with various changes). Appending the one file's daily new content to
the other is easy (and necessary because the overall list gets used in a
pivot table). But I have no idea how to synch up the two lists with changes
in the one pasted on the unchanged (or even worse, also changed) entries of
the other.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