newparadigmz

asked on

# excel vba, compare 2 tables, show differences

In the example given, what's the best way to generate Table 3 based on matching Tables 1 and 2 by Acct, then Prod, and comparing differences? Tables 1 and 2 will have varying rows each time.

Thanks!

compare.xlsx

Thanks!

compare.xlsx

ASKER

yes, side by side, that's the part i'm getting stick on

Hi, newparadigmz.

Is it OK if we sort the two input tables (e.g. so eee/eee111 appears before eee/eee333)?

Thanks,

Brian.

Is it OK if we sort the two input tables (e.g. so eee/eee111 appears before eee/eee333)?

Thanks,

Brian.

ASKER

yes!

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Thanks!

Just a question of clarification. You want table 3 to have all records under each other or side by side as you have done.

The reason I ask is that it should be fairly easy to generate the two tables under each other and then sort them, but if it is the comparison part that is the important part, it is somewhat more complex.

regards

Jørgen