Writing a macro to compare columns and return a value

[Ginny]

Hello,

I am trying to write a macro to compare 2 columns and then return a
scpeficied value. Eventually, I will have approx 5000 lines to compare in the
columns, so I am trying to create a macro with a specified function that will
do thi, but can't figure out the function.

Here is what I want:
I want to see if the specificed EMO_ID Numb (for example, the number in cell
B7, whcih is 83) can be found anywhere in the BSNIP_ID column. If it it
found, then I want the number in cell B7 (which is #83) to be copied over to
the adjacent column (Numbers found), in cell C7. Can a macro be written to
search, find, numbers, and return a value for approx 5000 numbers?

BSNIP_ID EMO_ID Numb Numbers found
1 1
2 2
3 3
4 4
21 40
26 40
28 83
40 86
42 93
44 94
83 118
86 139
93 145
94 176
118 205
122 233
126 239
129 263
135 270


Thank you for your help!

 

[Don Guillett]

Maybe a FINDNEXT macro would do as desired. Look in the vba help index.