asddsa88
03-07-2010, 07:28 AM
scenario:
column A with a list of names
column B with a list of names
1)I need to compare list B with A
2)if the text value of a cell from column B matches the text value of another cell from column A
3)move 2 cells to the right of the matching cell in column A and write something
example:
(sorry for the confusing ---- signs but the forum wouldn't let me insert blank spaces...)
COLUMN A----------- COLUMN B----------- COLUMN C
mark----------------- pete
pete -------------------------------------- OK
john
the value of b1 is matching the value of a2, so the macro has to select cell a2, move 2 cells to the right (c2) and write "OK"
I am not sure if vba macros support a dynamic search input where they can get the value to be searched from a cell text value.. is this possible?
column A with a list of names
column B with a list of names
1)I need to compare list B with A
2)if the text value of a cell from column B matches the text value of another cell from column A
3)move 2 cells to the right of the matching cell in column A and write something
example:
(sorry for the confusing ---- signs but the forum wouldn't let me insert blank spaces...)
COLUMN A----------- COLUMN B----------- COLUMN C
mark----------------- pete
pete -------------------------------------- OK
john
the value of b1 is matching the value of a2, so the macro has to select cell a2, move 2 cells to the right (c2) and write "OK"
I am not sure if vba macros support a dynamic search input where they can get the value to be searched from a cell text value.. is this possible?