snoopies
06-18-2005, 02:14 AM
Dear all,
I have an existing column(A) with brand names, & I need to update the list by adding new codes quite often..
My problem is... the new data which I receive is always in different order..:( (I put it in col D & e in my example.) The yellow cells are the raw data, you can see that the order of it is v. different to col A. Moreover, some brand names are new which appears in the first time...
I find it very time consuming to check it one by one with eyeball screening.. therefore, I want a macro to help this.. I hope col D&E can be sorted according to the sequence of colA and place all new brands at the bottom with red color... How can I achieve this...?
Thanks in advance.
Regards.
I have an existing column(A) with brand names, & I need to update the list by adding new codes quite often..
My problem is... the new data which I receive is always in different order..:( (I put it in col D & e in my example.) The yellow cells are the raw data, you can see that the order of it is v. different to col A. Moreover, some brand names are new which appears in the first time...
I find it very time consuming to check it one by one with eyeball screening.. therefore, I want a macro to help this.. I hope col D&E can be sorted according to the sequence of colA and place all new brands at the bottom with red color... How can I achieve this...?
Thanks in advance.
Regards.