Compare multiple rows of data to figure out the change and who made that change

[vapid2323]

Well just as the subject says I want to compare rows of data to see who made the changes.

I have a audit log that saves any change and tracks who did that change, the issue is that my users are not going to be able to read that data very well.

What I want is some VBA to analyze the data and figure out who changed it and then put it together into a box that users can clearly see what happened.

I wanted to see if anyone can give me pointers on how to get started, or any tips on how to make this happen.

See the sample of what I am trying to do:

 

[ted.martin]

The question seems straightforward but as ever, the answer can be complicated.

Essentially you need to compare two lines of data, albeit one from the original data and the other the latest set. Imagine how if you were doing it the hard way, you would have two sets of data and then compare row/column by row/column, side by side.

It may be useful to output one set of data to a temporary table and then compare field by field. It all depends how many fields are in play.

The comparison code will be straightforward as in If A <> B then ' its changed

Think the problem through the 'hard way' and then develop your code to give you the method and result you require.

 

[CBrighton]

The first 2 lines of the OP seem to contradict each other.

Why do you need to compare 2 rows of data when you have said you have an audit log?

Or is the audit log a single large field with a big string detailing the changes (similar to how your screen-print looks)? but I assume that's not the case as that's an example of what you hope to get as an end result so it's likely not like that in the table.


Can you please give details of your audit log (fields, etc)?