t_kid
04-20-2012, 11:34 PM
Hi guys,
I have a VBA problem and I was hoping you could help me. The problem is as follows.
I have 2 columns A and B, each with many names. I want to create a macro that takes the cell A1, and tells me if a cell in column B is equal, by writing "Y" in C1 if there is such a cell, and "N" otherwise.
I want the macro to do this for each cell in column A, and also have no repeats. So if there are 2 cells in column A with the name "James" but only 1 such cell in column B, then only the first "James" should find a match and display "Y" in column C.
Any help would be greatly appreciated.
I have a VBA problem and I was hoping you could help me. The problem is as follows.
I have 2 columns A and B, each with many names. I want to create a macro that takes the cell A1, and tells me if a cell in column B is equal, by writing "Y" in C1 if there is such a cell, and "N" otherwise.
I want the macro to do this for each cell in column A, and also have no repeats. So if there are 2 cells in column A with the name "James" but only 1 such cell in column B, then only the first "James" should find a match and display "Y" in column C.
Any help would be greatly appreciated.