S solti New Member Dec 16, 2016 #1 Hello, I have to compare with vba concatenated values from two columns in sheet1 against concatenated values in other two columns in sheet2 and if found make the rows in either of file red.... Could you please help s.
Hello, I have to compare with vba concatenated values from two columns in sheet1 against concatenated values in other two columns in sheet2 and if found make the rows in either of file red.... Could you please help s.
Marc L Excel Ninja Dec 17, 2016 #2 Hi ! No code : try a conditional format using MATCH worksheet function …
S solti New Member Dec 17, 2016 #3 The comparison is apllied to files which lenght change from month to month that's why I need macro
Marc L Excel Ninja Dec 18, 2016 #4 Despite MATCH worksheet function can be used within a code, you can also try the VBA Find method (to see in VBA inner help) …
Despite MATCH worksheet function can be used within a code, you can also try the VBA Find method (to see in VBA inner help) …