runningonempty
New Member
- Joined
- Aug 7, 2007
- Messages
- 35
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
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