league table without macros

Dear All,

My first post on this forum... I'm after a league table spreadsheet
that automatically sorts after entering results but I also want a
spreadsheet that doesn't use macros (pcs at work prevent the use of
macros - I understand why but its a pain still!).

I know this is possible from looking at this excellent freeware world
cup 2006 spreadsheet:
http://www.footballsupportersinterna...06/planner.htm

Ideally I'd like to adapt this spreadsheet for my needs but having
unhid all of the worksheets I'm blown away by just how complicated it
is: For each world cup group the worksheet is 9 PAGES LONG of what
seems like duplicated tables!!!

Could anyone help me understand this please or even point me to a
similar but simpler league table spreadsheet that doesn't contain
macros.

Any help appreciated...thanks in advance.

Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

As far as I am aware, there is no way of automatically triggering a sort
without a macro. I have a World Cup spreadsheet in which the only code
required is the sort and the sort "trigeer" i.e. an event which causes the
sort to be executed.

"gdh82" wrote:


Dear All,

My first post on this forum... I'm after a league table spreadsheet
that automatically sorts after entering results but I also want a
spreadsheet that doesn't use macros (pcs at work prevent the use of
macros - I understand why but its a pain still!).

I know this is possible from looking at this excellent freeware world
cup 2006 spreadsheet:
http://www.footballsupportersinterna...06/planner.htm

Ideally I'd like to adapt this spreadsheet for my needs but having
unhid all of the worksheets I'm blown away by just how complicated it
is: For each world cup group the worksheet is 9 PAGES LONG of what
seems like duplicated tables!!!

Could anyone help me understand this please or even point me to a
similar but simpler league table spreadsheet that doesn't contain
macros.

Any help appreciated...thanks in advance.

Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Toppers" wrote in message
news
As far as I am aware, there is no way of automatically triggering a sort
without a macro. I have a World Cup spreadsheet in which the only code
required is the sort and the sort "trigeer" i.e. an event which causes the
sort to be executed.

"gdh82" wrote:


Dear All,

My first post on this forum... I'm after a league table spreadsheet
that automatically sorts after entering results but I also want a
spreadsheet that doesn't use macros (pcs at work prevent the use of
macros - I understand why but its a pain still!).

I know this is possible from looking at this excellent freeware world
cup 2006 spreadsheet:

http://www.footballsupportersinterna...06/planner.htm

Ideally I'd like to adapt this spreadsheet for my needs but having
unhid all of the worksheets I'm blown away by just how complicated it
is: For each world cup group the worksheet is 9 PAGES LONG of what
seems like duplicated tables!!!

Could anyone help me understand this please or even point me to a
similar but simpler league table spreadsheet that doesn't contain
macros.

Any help appreciated...thanks in advance.

Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
View this thread:
http://www.excelforum.com/showthread...hreadid=557213

Thanks Topper and Bob Phillips for your replies - its much appreciated.

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

How complicated should this be, Bob ? Only the worldcup spreadsheet
seems to have 27 versions of the table (over a 9-page worksheet) which
I imagine are at varying stages of sorting? This seems too complicated
? Would you happen to know of a simpler spreadsheet by any chance ?


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

All of the world cup spreadsheets that I have seen are all very complicated,
probably due to in part the authors trying to give them a special look and
feel associated with Germany 2006.

I have a league table which uses VBA, but I will try and adapt it over the
next few days to be VBA free. If you send me your email address I will
notify you if and when it is done.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

Thanks Topper and Bob Phillips for your replies - its much appreciated.

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

How complicated should this be, Bob ? Only the worldcup spreadsheet
seems to have 27 versions of the table (over a 9-page worksheet) which
I imagine are at varying stages of sorting? This seems too complicated
? Would you happen to know of a simpler spreadsheet by any chance ?


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

I have a league table which uses VBA, but I will try and adapt it over
the
next few days to be VBA free. If you send me your email address I will
notify you if and when it is done.

Thanks very much for this offer, Bob - I'll send you my email
details shortly. Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.

If you'd like a copy send me a PM with your email address


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213

Thanks daddylonglegs, I'd be grateful of a copy of your league
spreadsheet ! PM on the way!! Thanks again Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

Please send me one copy to
Many thanks
Joaquim

"daddylonglegs"
wrote in message
news:daddylonglegs.2abmlz_1151848804.8015@excelfor um-nospam.com...

I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.

If you'd like a copy send me a PM with your email address


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213

Daddy,

I am in the middle of creating my own, but a couple of questions on how you
address certain points.

Do you allow for different points scoring systems? I do, by just having a
data sheet with the points for home and away wins, and a draw. How about
you?

How do you manage the change of teams over year to year?

How do manage the fact that say you have created the table for 20 teams and
someone else wants to setup a 22 team table? I am thinking here specifically
of ensuring the derived data automatically picks up the extra data.

Thanks

Bob


"daddylonglegs"
wrote in message
news:daddylonglegs.2abmlz_1151848804.8015@excelfor um-nospam.com...

I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.

If you'd like a copy send me a PM with your email address


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213