If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
league table without macros
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 |
#3
|
|||
|
|||
league table without macros
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 |
#4
|
|||
|
|||
league table without macros
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 |
#5
|
|||
|
|||
league table without macros
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 |
#6
|
|||
|
|||
league table without macros
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
three table database | ricardozelaya | Database Design | 3 | April 25th, 2006 12:15 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |