I am trying your macro now. Do I need to press anything after I paste the codes? Nothing is happening on my sheets.

Change or add or remove a value on Sheet 1 and Sheet 2 will change.

Nothing happens. Sorry, I know I am doing something wrong. The Sheet2 must be completely clean?

It doesn't matter if Sheet 2is clear or not.

You mean on the VBA /Macros window? I did.

I changed the code to easily reference to the sheets in the lines Set wks = wkb.Worksheets("Sheet1") and Set wks1 = wkb.Worksheets("Sheet2"). Paste the code, check that you put the code of the Workbook. Save, close, open again, activate macros and it should work.

No, sorry. I got nothing. I created a new excel file from scratch. On sheet1 I used columns A B C D and rows from 1 to 6. The first row is just the header with the team names. The first cell is blank. I inserted the values from A2 to D6. I opened up the VBA /Macros window and double clicked on Sheet1. I pasted the first long code you gave me. I then clicked on "this workbook" and pasted the second one. I saved my file. I changed the value of a cell but still nothing happens. I have Excel 2010 by the way.

Is your Excel disabling macros by default?

support.office.com/en-us/article/…

It was, but I already changed the settings to accept them

It is enabled now but still no use

I don't know...

yes, its weird

are you sure i dont need to press anything after I paste the codes?

No. Do you want me to send you my file, just to test ?

sure

is there any way to send it from here?

In Dropbox

dropbox.com/s/mligz4tu2k0f3lc/sort_results.xlsm?dl=0

just a moment

I downloaded yours and I have the same problem, nothing happens

ahh, okay, never mind, I didnt know I had to close the macros window first

Is it working?

yours is working now

mine is still not working

im sending it to you

Well, use mine.

I would appreciate if you have a look at it and see whats the problem

because my actual file is much more complex so I want to understand how it works in order to adapt it

Ok. Send me the file.

mega.nz/#!kxwBXLjQ

please download from here

It is asking me a key

weird, there is not such a key

ahh, the download?

Megas is asking me that before downloading the file

mega.nz/#!kxwBXLjQ!McFVrcmqOb8H4NeQ_iOQLdPcYLvp5GrFIFOQ5Zf4a_U

here, sorry

Downloaded, I'll check it

thanks

good, it works now, thank you very much

by the way, do you happen to know the ASAP utilities?

I know what it is ASAP utilities, but I have never used it.

I have it installed, it has a function that allows you to sort by more than one criteria

is it possible to use your macro like that so it sorts not only by goals total but also by goal difference and so on?

It's possible but it will need to create a second column with the diffrence values, and modify the Sort line.

all in the macro?

I will give it a try

thank you for your help and time again, I appreciate it

see you