Hi, I'm very new to Microsoft Excel, and all I know is primarily self taught, as in my course we focussed on the use of Microsoft Access instead. Anyway, my query is as follows:

I've made a spreadsheet for the football world cup. I have one sheet with the fixtures in, and one with the groups that take data from the fixtures to make the group tables. My problem with the sorting is as follows:

Because of the way the groups are done, I've got them sorted firstly by points descendingly, secondly by goal difference, then thirdy by goals scored. When I enter results for the fixtures in the first sheet, it updates the table for results and points, but doesn't update the sorting. I have to go Data - > Sort and press OK again for it to Sort again.

Is there any way to update Sort automatically?

Thanks for any help.