Please help with the following Macro:
At the stroke of a key eg. (Cntl R)
<colgroup><col></colgroup><tbody>
</tbody>
At the stroke of a key eg. (Cntl R)
Select entire column A |
Sort Column A |
Remove duplicates in column A |
select entire column B |
Sort Column B |
Remove duplicates in column B |
Cut all data from B1 to last non empty cell |
select first empty cell in column A |
Paste data into first empty cell in column A |
Delete entire column B Thank you |
<colgroup><col></colgroup><tbody>
</tbody>