Hello,

I wish to create a macro which sorts my column based on the values in it. Once data has been copied into my spreadsheet, column K shows "Priority 1" or "Priority 2".

I want the macro to sort column K with the Priority 1 cells at the top and then the Priority 2 cells.

Can anyone help please?


Regards,


Chris

Macro Issue.JPG