Hey guys

I have 2 Columns of data. Columns M and N. The data in
both columns starts in Row2 and goes through Row100. I
need a code that will have ColumnN look in ColumnM for
values. If a value is in ColumnM, that same value needs
to be in ColumnN. The code needs to put that value at the
end of the last value in ColumN. Also if a value that was
in ColumnM is deleted, then that value will need to be
removed from columnN.

This means the values in columnM can change in 3 ways.
The order in which the values are listed in columnM may
change, a new value will be added to columnM, or a value
will be deleted in columnM. All I need for ColumnN to do
is just make sure all the values in ColumnM are in ColumnN
and no more. This means the values in columnN can change
in only 2 ways. Either by deleting a Value(only if the
value is no longer in ColumnM) or by adding a value(only
if a new value is added to ColumnM).

Thanx

Todd Huttenstine