Hi,
Is there a way to list the differences in values between two identical tables.
Table - 1
BA | BB | BC | BD | BE
AA| 234| 235 | 466 | 235 | 234
AC| 235| 534| 45 | 26 | 235
AF| 34| 869| 345 | 346 | 632
Table - 2
BA| BB| BC| BD| BE
AA| 233| 235| 466| 235| 234
AC| 234| 534| 44| 26| 235
AF| 35| 869| 346| 345| 632
Result
Sl. No.| Description| Table 1| Table 2| Difference
1| AA - BA | 234| 233| 1|
2| AC - BA | 235| 234| 1|
4| AC - BC| 45| 44| 1|
I want the difference between the table 1 and table 2 to be listed in the result table in the
way above. Is there any shortcut or macro to do this. Please help me.
Thanks,
Yathish D
Bookmarks