VBA is certainly the best option I can think of.

Assuming records are not added, a simple sort of the table on the unique ID
should put the records in the same order.

there are many ways to approach this and it would really require knowledge
of what you have and what you want to do.

The brute force method would be to either loop through the master or to loop
through the revised database and compare between the two, identify the
differences and then do what?

Another apporach would be to consolidate all the data into one workbook with
each set of data marked on each record as to the source. then you can do
sorts and comparisons with your code all at once.

Not sure what you expect to get out of your post. But, given no specific
information, your general description would say that VBA is a manageable way
of doing this. Of course if you are not experienced with VBA, then it might
not be the best way.

--
Regards,
Tom Ogilvy
"tarynnl" wrote in message
...
I have a database which gets sent to clients and they make changes save
it as a seperate workbook and it gets sent back and not necessarily in
the same order as it was sent

What i want to be able to do is make a comparison by looking up the
unique id for each record and seeing what fields have been changed

Not sure if VBA is the best way to sort this out but i have about 40 of
these databases that get sent out with the same amount of responses and
to sit and read through each one to see where the changes are a
nightmare

Any Suggestions?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/