harithaa19
New Member
- Joined
- Jun 12, 2019
- Messages
- 1
Hi All, I'm new to Macros and VB and stuck at a point. Hope you can help.
The requirement is to compare two worksheets in an excel and highlight the rows in which have a mismatch in Yellow. I already have a Macro for this which imports .cvs files into excel, sorts the data and then compares cell by cell and highlights the differences.
Im stuck at this point - I want to select the entire rows where the cell is highlighted in Yellow and paste all these rows in a new worksheet called Differences. Im unable to use excel filter by cell color coz I do not know which column might have a mismatch. Can you please help?
The requirement is to compare two worksheets in an excel and highlight the rows in which have a mismatch in Yellow. I already have a Macro for this which imports .cvs files into excel, sorts the data and then compares cell by cell and highlights the differences.
Im stuck at this point - I want to select the entire rows where the cell is highlighted in Yellow and paste all these rows in a new worksheet called Differences. Im unable to use excel filter by cell color coz I do not know which column might have a mismatch. Can you please help?
