Need elp comparing two columns in VBA
 

Hello all. I'm a newbie to this website and to VBA and I need to
compare two columns. Column A, and Column B. These columns are not of
equal length and contain many duplicates. I need to have column B to
be output into a drop down box on a userform, if and only if column A
is equal to column B. for example:

(column A) (column B)
old dominion university college
virginia commonwealth universiry college
tallwood high school high school
kempsville high school high school

..... on my userform there is a drop down box for column b that
contains: college, high school, etc. also, there is another drop down
box for column a that contains: odu, vcu, ths, khs, etc.

i need to know how to parse each box so that one school shows up in
the column a drop down box and only shows if the info in column b is
what it pertains to.


I'm looking for VBA code to help do this :)

Thanks very much.