|From reading your post, you want your whole sheet to be sorted according to the column headed COE, correct?|
If so try this:
First create your Macro:
On the Task Bar,
Record New Macro,
A small window should open,
Give the Macro an appropriate name, like “SortbyCOE”
A small box with the word “Stop” should appear.
If it does not don’t worry, will take care of it later.
Place your cursor on the small box area that is above row number 1 and next to the column letter A and left click, this will select the entire sheet.
On the Tool Bar,
Check the “Header Row” button near the bottom, under the heading “My List Has”.
Change the “Sort by” to the heading “COE”
Your sheet should sort.
Put your cursor on cell A1 and left click,
This will be the default location for the cursor after the sort.
Click the “Stop” button to end the macro.
If there is no Stop button, then, On the Task Bar
Click on Stop Recording Macro
Create a button for the macro
On the Task Bar
In the small window, under “Categories”,
Scroll down and click on “Macros”
The right panel should change and there should be a smiley face next to “Custom Button”
Left click on the smiley face, hold and drag up to the Task Bar and let go.
Where, on the Task Bar, you put it is up to you. I usually place it on the far left or next to the Help button.
Click “Close” on the small window.
Next, click on the smiley face button and another window opens that reads “Assign Macro”
Find your “SortbyCOE” macro and double click and your done.