That will not work because the values cannot change in
ColumnN if the only thing thats happening is the values
are just moving around in ColumnM.

I am trying to create more of a constant with ColumnN.




-----Original Message-----
Both columns have the same number of rows. Column N is
supposed to contain the same values that
are in column M. So why not just put a formula in N2,
=M2, and copying down through N100 ??


On Sun, 30 Nov 2003 17:12:35 -0800, "Todd Huttenstine"

wrote:

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

.