- Joined
- Sep 7, 2010
- Messages
- 2
- Reaction score
- 0
I am trying to complete a quick project for an excel sheet at work the general outline is this:
I want to compare a coloumn of text in sheet 1 with a coloumn of text in sheet 2.
If the text in sheet 1 is found anywhere in the coloumn in sheet 2 then highlight the row in sheet 1 which contains the text.
This process should be repeated for each text value in sheet 1.
I have only coded in Java before and am finding it very difficult to pickup a decent site with syntax outline for this problem if anyone could help me out either with code or point toward a decent site it would be greatly appreciated.
I want to compare a coloumn of text in sheet 1 with a coloumn of text in sheet 2.
If the text in sheet 1 is found anywhere in the coloumn in sheet 2 then highlight the row in sheet 1 which contains the text.
This process should be repeated for each text value in sheet 1.
I have only coded in Java before and am finding it very difficult to pickup a decent site with syntax outline for this problem if anyone could help me out either with code or point toward a decent site it would be greatly appreciated.