cmp two tables:in VBA
Hello
There are two tables with identical columns - 5 columns each. A column can have text or numbers in them. How do do a compare so that I compare each cell value of table1 to table2 for the same row and column and if there is a difference, I highlight or indicate it in both tables…for example
Please see the attached….how do I do that in vba. Can the same by done via formulas?
questionFor.xlsx
There are two tables with identical columns - 5 columns each. A column can have text or numbers in them. How do do a compare so that I compare each cell value of table1 to table2 for the same row and column and if there is a difference, I highlight or indicate it in both tables…for example
Please see the attached….how do I do that in vba. Can the same by done via formulas?
questionFor.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this is amazin, thank you Sire :)
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
He's a hoot! ;)
I know I am late to the party, but here is a different approach (using Conditional Formatting on the range [J:N]), that does not need any Visual Basic for Applications code (although I appreciate that this was your requirement when posting the question).
The Conditional Formatting in cell [J1], for instance, is: =OFFSET(J1,0,-9)<>J1
However, I acknowledge that you may well just wish to apply from rows 3 onwards.
Q-28706581.xlsm
I know I am late to the party, but here is a different approach (using Conditional Formatting on the range [J:N]), that does not need any Visual Basic for Applications code (although I appreciate that this was your requirement when posting the question).
The Conditional Formatting in cell [J1], for instance, is: =OFFSET(J1,0,-9)<>J1
However, I acknowledge that you may well just wish to apply from rows 3 onwards.
Q-28706581.xlsm
ASKER
thank you fanpages :)
This is awesome too, a one liner
This is awesome too, a one liner
:) You're very welcome, Rayne.
You're welcome Rayne! Glad I could help. :)
ASKER
thank you