Dreamteam banter thread ;)

[Wiz]

cheers m8

but can you change my team name please its taffy's flock

Tis done

 

[Magik]

Dutcho / mkmagik786
Would it be possible to put a auto adding league table on the spreadsheet? or is that beyond the realms of possibility?

You can select the table tab then highligh all the team names and all the points totals only. Now go to data/sort. Click on no header row at the bottom. Select column F in sort by, then click descending.

The table tab will now show full league standings in order.

I'll see if i can fidldle with the speadsheet to make it easier.

 

[Magik]

Wiz/Dutcho,

Right... i've added a simple macro to the table sheet. When you update the players points the values in the table change. so click on the SORT button in the table sheet and it will auto sort it in descending order.

Check it and see if its worth using for you.

Its not much, but give me a little time and i'll see if i can make the spreadsheet a little improved. Don't hold ya breath though......lol.

 

[TheDogsNutts]

nice work m8..............

 

[Dutcho]

Cheers mate, I thought of a macro but just anit found the time to have a fiddle

 

[thomson]

Iam getting this problem (see attachment).

How do I get it to stop displaying this ?

 

[Dutcho]

You need to adjust your security level in excel, think its in tools

 

[thomson]

You need to adjust your security level in excel, think its in tools

ok , thanks mate, got it sorted

 

[Magik]

for those who don't know where the security is.

tools/macro/security - set it to low or medium.

 

[Wiz]

Wiz/Dutcho,

Right... i've added a simple macro to the table sheet. When you update the players points the values in the table change. so click on the SORT button in the table sheet and it will auto sort it in descending order.

Check it and see if its worth using for you.

Its not much, but give me a little time and i'll see if i can make the spreadsheet a little improved. Don't hold ya breath though......lol.

Nice work m8 :salute:

 

[Magik]

Wiz/Dutcho,
Take a look and see if it's of use - please read PM for explanation of how it should work.

It should be up to date of this weeks points as well.

 

[Dutcho]

Will do m8, cheers for that. Wizzy will have to pick which he prefers as totals are his head ache

 

[Wiz]

Great work m8, looks good :salute

 

[Wiz]

Would u look at that, the cream is startin to rise to the top......

 

[Dutcho]

Foooooooker.... If your happy with it m8 use it, so long as you know what your doing

I'm happy if you are.

 

[mickeyb]

The cream is still at the top!

 

[Magik]

There are a couple of mistakes on teh spreadsheet above. I'll sort them out and repost tonight.

 

[Magik]

Right league table was a bit out of wack - Nutty's Dogs, Team Value and Jonty dog had someone elses points.

This is the right version now.

 

[Wiz]

The cream is still at the top!

Lol, wel done m8 still going strong

 

[Magik]

Wiz,
Even more updated - should give you the weeklys you want and i've added a simple bit for Transfers. Details PM'ed to ya as theres a little bit of work needed.

Let me know if you can use it!