Quick Sort Macro Query

[runningonempty]

Hi All

Heres my problem:

I have two colums of unsorted data, each column with cells that match or do not match another cell in the other column.

Problem:

I need a macro to

a) sort both columns in ascending order
b) align cells from each column that match so we have a row of two identical cells
c) move unmatched cells to the bottom of the list and highlight these cells in red

Please leave room in your macro so that I can expand the selection if at a later date I have to sort out not just two columns but 2 tables or groups of columns by a common or key/ primary column

Many Thanks