Sort and compare multiple database outputs identifying variances.

[Dilbet]

Need help sorting and comparing output from 2 databases to identify inconsistencies. If an account and product is missing from one database a blank row should be inserted if variances are identified in quantities and value they should be highlighted .
If a missing .

The database currently has approx 800 accounts and growing .

Output sample attached

[Alf]

Perhaps this macro solution will work for you?

Run macro “Compare” to test.

When using this macro layout must be same as in your uploaded file. When doing value comparison I found out that in Database 1 you had 7 decimals (formatting only shows 2) but in Database 2 you only have 2 decimals.

The fix for that was to use the ROUND function setting decimals to 2 on both databases. This will not change your original values it just trims them when doing the comparing.

Alf

[Dilbet]

Hi Alf thanks your macro worked great ... when running the macro against the entire database I've identified accounts that exist in Database # 2 ... is it possible to adjust the macro to enter a blank row in database # 1 as it does in Database #2

[Alf]

is it possible to adjust the macro to enter a blank row in database # 1 as it does in Database #2

Sorry not possible. That will require a different approach. There is something funny about your data my guess is you copied tables as there seems to be limitations on what I can do with it. Have not managed to break this "conditional" setting yet.

But as this has solved your original question I suggest you mark this thread "Solved" and post a new thread your added request.

Alf

Ps Tanks for comments and rep. Will look at possible solutions to your added request but in the meantime you will be better off by posting a new thread and get help from other forum members. When posting the new thread PM the link to me.

[Kyle123]

Can't you do this in the database they came from? This is trivial in SQL