Hey
I need VBA code that searches values entered into column A and B (loads of rows) in Sheet1 and then highlights if that row of data is present in the same columns but in a different sheet (Sheet2).
I'm working in Workbook_SheetSelectionChange - it has to check if the values exist as soon as the user goes onto the next row.
I've attached pictures as a demo:
Sheet1:
http://img508.imageshack.us/img508/107/ex1qc5.jpg
Sheet2:
http://img76.imageshack.us/img76/4944/ex2as3.jpg
In the example above (Sheet1), as soon as the user finishes typing the age for Cat and hits return , the row Cat is in would be highlighted in both Sheets as the name and age match. The same goes for when the user hits return after typing the dogs age as they both match.
The number of rows is going to be unknown.
Thanks
I need VBA code that searches values entered into column A and B (loads of rows) in Sheet1 and then highlights if that row of data is present in the same columns but in a different sheet (Sheet2).
I'm working in Workbook_SheetSelectionChange - it has to check if the values exist as soon as the user goes onto the next row.
I've attached pictures as a demo:
Sheet1:
http://img508.imageshack.us/img508/107/ex1qc5.jpg
Sheet2:
http://img76.imageshack.us/img76/4944/ex2as3.jpg
In the example above (Sheet1), as soon as the user finishes typing the age for Cat and hits return , the row Cat is in would be highlighted in both Sheets as the name and age match. The same goes for when the user hits return after typing the dogs age as they both match.
The number of rows is going to be unknown.
Thanks