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.


--
thebottomline
------------------------------------------------------------------------
thebottomline's Profile: http://www.excelforum.com/member.php...o&userid=35290
View this thread: http://www.excelforum.com/showthread...hreadid=550780