IF and Lookup functions
 

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/

IF and Lookup functions
 

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/

IF and Lookup functions
 

Just some thoughts...

Another way is to track the changes as they happen.

For example, the following code in the worksheet code window will enter
"Changed" in column A in the row that changes.

'***
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Cells(Target.Row, "A").Value = "Changed"
Application.EnableEvents = True
End Sub
'***

Of course the above code only works on single-cell input, I just want to give
you the idea.

A variant method is to build a UserForm interface, but then things are getting
more complex (but safer), so it depends on your VBA experience.

HTH
Anders Silvén

"Tom Ogilvy" skrev i meddelandet
...
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/