B
bastard_kestrel
Hello,
I'm new to VBA and wondered if someone could help me out please, as I
don't really know my arse from my elbow ?
I've got an Excel spreadsheet with 2 sheets.
Sheet1 only has values in the first column (A1 to A50)
Sheet2 has values over a larger range (A1 to K500)
I need to be able to look at the value in Sheet1 A1 and search for it
in the range A1 to K500 on Sheet 2.
If the value appears anywhere on Sheet 2 I need to highlight the cell
(on sheet 2) somehow and also insert "found" next to the value (in
column B) on Sheet1.
If the value does not appear on Sheet 2 anywhere I need to check the
value in Sheet1 A2 against the range on Sheet2 . . . .and so on (Hope
this makes sense)
Is this possible ?
Any help or advice would really be appreciated
Thanks
I'm new to VBA and wondered if someone could help me out please, as I
don't really know my arse from my elbow ?
I've got an Excel spreadsheet with 2 sheets.
Sheet1 only has values in the first column (A1 to A50)
Sheet2 has values over a larger range (A1 to K500)
I need to be able to look at the value in Sheet1 A1 and search for it
in the range A1 to K500 on Sheet 2.
If the value appears anywhere on Sheet 2 I need to highlight the cell
(on sheet 2) somehow and also insert "found" next to the value (in
column B) on Sheet1.
If the value does not appear on Sheet 2 anywhere I need to check the
value in Sheet1 A2 against the range on Sheet2 . . . .and so on (Hope
this makes sense)
Is this possible ?
Any help or advice would really be appreciated
Thanks