Hello and thanks for the quick reply.
Sounds complicated for me but I will definitely try it. I have to sort it
out by next week as have to send everything out then. Thanks again.
Soz

"moi" schrieb:

The macro has 3 parts:
- a class module, there an event handler is declared
- a module, this one has an auto_opener, to activate/install the event
handler
- a piece of code in Sheet1, which actally is the event handler that
triggers any change in the workbook
this last one calls a sort macro which needs to be put in a 'normal module',
not in a class

Just check out help for 'events' and you'll see that you can do a lot more,
BeforeSave, BeforeClose, ActivateSheet - those are all events that you can
make Excel respond to in your own way.


"Soz" schreef in bericht
...
Hello and many thanks for your help.
I see how it works but would it be possible to tell me how to set up the
macro so I can incorporate it into the spreadsheet which I am currently
using.
Again many thanks
Soz

"moi" schrieb:

You can use an event listener which checks for a change of points and
sorts
the second list if so.
A simple sample is he
http://www.geocities.com/smplprgrsrc...all_League.zip




"Soz" schreef in bericht
...
Who can help please?
I am running a football league for a group of friends. I have a table
which
shows how many points each one has accumulated. I use the "range"
function
to
show which position each person has in the league. What I would like to
do
is
to have on a separate table the same list but this time I would like it
to
show their names just like a normal league table, ie. most points at
top,
least at bottom.
I have 3 columns, Column A has a list of names, Column B shows their
position and Column C has their points. At the moment we are 30 people.
Can someone help to make a proper table.
Hope so.
Best regards
Soz