Hi chaps
I run a Fantasy League for some friends at work and friends of friends etc.
There are 57 teams in my league this year and I am having a problem with one of the macro's in the spreadsheet I use (it was written by an old friend of a friend a few years back).
Basically there is a Top Scorers tab where I normally just copy and paste the list of players and scores etc into. I then click on a button called Sort Top Scorers which basically sorts the Top 20 for me.
Now I've added in a few new players since the last update it is missing off or not calculating the last few (ID's 993-999 which appear after Row 397 in the worksheet) correctly.
I've had a quick look at Macro and cannot see any reference to a number of rows or anything so am stumped and need an experts help...
Here's the Macro btw... (It could be something simple) or alternatively if someone wants to take a look I can email the spreadsheet over.
Here's the Macro...
'----------------------------------------------------------------------------------
' SortScorers Macro
' Sort Top Scorers Table
' Macro recorded 23aug96 at 08:43 by Mark Fulgoni
'----------------------------------------------------------------------------------
Sub SortScorers()
' select top scorers sheet
Sheets("Top Scorers").Select
' clear top 10 filter and select the whole table
Selection.AutoFilter Field:=1
Application.Goto Reference:="scorers"
' clear background and font settings
Call ClearAttributes(False)
' sort top scorers table by points, value, times selected
Selection.Sort _
Key1:=Range("H2"), Order1:=xlDescending, _
Key2:=Range("F2"), Order2:=xlAscending, _
Key3:=Range("G2"), Order3:=xlAscending, _
Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False
' set headings black background, white text
Range("B1:H1").Select
Call MakeHeading
' set gray background for every second row
Call GrayBackground(2, 399, 2, "B", "H")
' re-apply top xx filter
Application.Goto Reference:="scorers"
Selection.AutoFilter _
Field:=1, _
Criteria1:="20", _
Operator:=xlTop10Items
' de-select table range
Call ReturnToTop
End Sub
Sub FormatPlayers()
Sheets("Players").Select
Call GrayBackground(2, 399, 2, "A", "I")
Call ReturnToTop
End Sub
Thanks in advance
WJUK
Spreadsheet Help - Please
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Spreadsheet Help - Please
Application.Goto Reference:="scorers"
This looks like there is a Named range in the sheet called "scorers" so you may need to extend that first.
Just a guess though.
This looks like there is a Named range in the sheet called "scorers" so you may need to extend that first.
Just a guess though.
- Mystery
- FISO Knight
- Posts: 13816
- Joined: 13 Oct 2005, 18:33
- Location: Just about here
- FS Record: 116th in TFF 05/06
- FPL:
- Contact:
Re: Spreadsheet Help - Please
I don't think the Application lines are necessary at all. Unless you've got gaps in your list AutoFilter should guess the range perfectly fine without you pointing at it, as long as you select a cell in the range.
-
- Newbie
- Posts: 1
- Joined: 02 Oct 2012, 10:09
Re: Spreadsheet Help - Please
What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
- Vid
- Head Moderator
- Posts: 21728
- Joined: 13 Oct 2005, 18:33
- FS Record: winning is a distant memory
- FPL:
Re: Spreadsheet Help - Please
=(C3 * D3) + E3clarisha wrote:What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
- Knulpuk
- Dumbledore
- Posts: 8986
- Joined: 05 Dec 2005, 13:22
- Location: MTA (Mid Table Anonymity)
- FS Record: Ultra ultra consistent (see above)
- FPL:
Re: Spreadsheet Help - Please
Vid wrote:=(C3 * D3) + E3clarisha wrote:What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
- murf
- FISO Viscount
- Posts: 109450
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Spreadsheet Help - Please
=(C3*D3)+E3
No spaces
No spaces
- Vid
- Head Moderator
- Posts: 21728
- Joined: 13 Oct 2005, 18:33
- FS Record: winning is a distant memory
- FPL:
Re: Spreadsheet Help - Please
true, I just copied and pasted from the Q and added the = ( )murf wrote:=(C3*D3)+E3
No spaces
- Knulpuk
- Dumbledore
- Posts: 8986
- Joined: 05 Dec 2005, 13:22
- Location: MTA (Mid Table Anonymity)
- FS Record: Ultra ultra consistent (see above)
- FPL:
Re: Spreadsheet Help - Please
C3 * D3 + E3
you don't even need the brackets, wait a minute is this one of these internet wind up things I have heard about
you don't even need the brackets, wait a minute is this one of these internet wind up things I have heard about
View Latest: 1 Day View Your posts