Copy (range} from worsheets to "Results" sheet

bdiddy

New Member
Joined
Jan 25, 2011
Messages
11
Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
Excel 2007<o:p></o:p>
<o:p></o:p>
PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied from “sheet 2”, Player 2 from “sheet 3”, and so on… My goal is to reference each sheet in the loop and extract the range (“A10:D10) and copy this to the Results page as well so it can sorted by highest to lowest. The VBA code below shows what is being run and the image shows the current output. At the moment columns (A, B, C, and D are in use for current output to the “Results” sheet and not available for. I will use these for Players only.<o:p></o:p>
<o:p></o:p>
VBA CODE:<o:p></o:p>
<o:p></o:p>
Public Sub PGA_SummaryArray()<o:p></o:p>
Dim ws As Worksheet<o:p></o:p>
Dim count As Long<o:p></o:p>
count = 0<o:p></o:p>
x = 1<o:p></o:p>
<o:p></o:p>
Application.DisplayAlerts = False<o:p></o:p>
On Error Resume Next<o:p></o:p>
<o:p></o:p>
Sheets("Results Summary").Delete<o:p></o:p>
On Error GoTo 0<o:p></o:p>
Application.DisplayAlerts = True<o:p></o:p>
Sheets.Add After:=Sheets(ThisWorkbook.Sheets.count)<o:p></o:p>
ActiveSheet.Name = "Results Summary"<o:p></o:p>
Columns("A:A").ColumnWidth = 12.75<o:p></o:p>
Columns("B:B").ColumnWidth = 13.75<o:p></o:p>
Columns("C:C").ColumnWidth = 15.75<o:p></o:p>
Columns("D:D").ColumnWidth = 13.75<o:p></o:p>
<o:p></o:p>
For Each ws In Worksheets<o:p></o:p>
If ws.Name <> "pga_list" And ws.Name <> "Results" And ws.Name <> "Results Summary" Then<o:p></o:p>
ws.Range("A10:D10").Copy Destination:=Sheets("Results Summary").Range("A1").Offset(count, 0)<o:p></o:p>
<o:p></o:p>
End If<o:p></o:p>
Next ws<o:p></o:p>
End Sub<o:p></o:p>
<o:p></o:p>
<TABLE style="MARGIN: auto auto auto 4.8pt; WIDTH: 309pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=412><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 233pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=311 colSpan=3 noWrap>
Player 1<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>
Player ID<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=124 noWrap>
Name<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=120 noWrap>
Purse<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
14<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Bill Lunde <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$132,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
15<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Francesco Molinari <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$107,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
3<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Graeme McDowell <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$412,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
30<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Stuart Appleby <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$57,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
2<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Robert Garrigus <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$635,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
18<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Ernie Els<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$87,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
4<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Carl Pettersson <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$286,500.00 <o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 16.5pt; mso-yfti-irow: 9"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>Player 1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #3f3f3f 2.25pt double; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=124 noWrap>
Total Earnigs =<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=120 noWrap>
$1,716,500.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 16.5pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" width=101 noWrap>
Score = -14<o:p></o:p>

</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 10"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=67 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=124 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=120 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 11"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 233pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=311 colSpan=3 noWrap>
Player 2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 12"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>
Player ID<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=124 noWrap>
Name<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=120 noWrap>
Purse<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 13"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
9<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Dustin Johnson <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$162,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 14"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
3<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Graeme McDowell <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$412,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 15"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
4<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Carl Pettersson <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$286,500.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 16"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
4<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Carl Pettersson <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$286,500.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 17"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
11<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Jason Day <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$162,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 18"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
15<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Francesco Molinari <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$107,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 19"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
10<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Jim Furyk <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$162,000.00 <o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 16.5pt; mso-yfti-irow: 20"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>Player 2<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #3f3f3f 2.25pt double; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=124 noWrap>
Total Earnigs =<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=120 noWrap>
$1,578,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 16.5pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" width=101 noWrap>
Score = 20<o:p></o:p>

</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 21"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=67 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=124 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=120 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 22"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 233pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=311 colSpan=3 noWrap>
Player 3<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 23"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>
Player ID<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=124 noWrap>
Name<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=120 noWrap>
Purse<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 24"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
10<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Jim Furyk <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid #B2B2B2 .5pt; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$162,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 25"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
15<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Francesco Molinari <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$107,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 26"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
20<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Matt Bettencourt <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$75,500.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 27"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
30<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Stuart Appleby <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$57,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 28"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
11<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Jason Day <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$162,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 29"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
18<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Ernie Els<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$87,000.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 30"><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #b2b2b2 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" vAlign=bottom width=67 noWrap>
30<o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=124 noWrap>Stuart Appleby <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid #B2B2B2 .5pt; mso-border-right-alt: solid #B2B2B2 .5pt" vAlign=bottom width=120 noWrap>
$57,000.00 <o:p></o:p>


</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR><TR style="HEIGHT: 16.5pt; mso-yfti-irow: 31"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" width=67 noWrap>Player 3<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #3f3f3f 2.25pt double; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=124 noWrap>
Total Earnigs =<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #3f3f3f 2.25pt double; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #a5a5a5; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #3f3f3f 2.25pt double; PADDING-TOP: 0in; mso-border-top-alt: double #3F3F3F 2.25pt" width=120 noWrap>
$707,500.00 <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #b2b2b2 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #ffffcc; HEIGHT: 16.5pt; BORDER-TOP: #b2b2b2 1pt solid; BORDER-RIGHT: #b2b2b2 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid #B2B2B2 .5pt; mso-border-left-alt: solid #B2B2B2 .5pt" width=101 noWrap>
Score = 20<o:p></o:p>


</TD></TR><TR style="HEIGHT: 15.75pt; mso-yfti-irow: 32; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=67 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 93.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=124 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 89.9pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=120 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 76pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap></TD></TR></TBODY></TABLE>​
Thanks in advance for any help or assistance. This MB has been very helpful!<o:p></o:p>
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

You never did anything with your counter. But this is a bit of a cleaner approach:

<font face=Calibri><SPAN style="color:#00007F">Public</SPAN> <SPAN style="color:#00007F">Sub</SPAN> PGA_SummaryArray()<br>    <SPAN style="color:#00007F">Dim</SPAN> ws <SPAN style="color:#00007F">As</SPAN> Worksheet<br>        <br>        Application.DisplayAlerts = <SPAN style="color:#00007F">False</SPAN><br>        <SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">Resume</SPAN> <SPAN style="color:#00007F">Next</SPAN><br>        <br>            Sheets("Results Summary").Delete<br>        <br>        <SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">GoTo</SPAN> 0<br>            <br>            Sheets.Add After:=Sheets(ThisWorkbook.Sheets.count)<br>            <SPAN style="color:#00007F">With</SPAN> ActiveSheet<br>                .Name = "Results Summary"<br>                .Columns("A:A").ColumnWidth = 12.75<br>                .Columns("B:B").ColumnWidth = 13.75<br>                .Columns("C:C").ColumnWidth = 15.75<br>                .Columns("D:D").ColumnWidth = 13.75<br>            <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br>        <br>            <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> ws <SPAN style="color:#00007F">In</SPAN> Worksheets<br>                <SPAN style="color:#00007F">If</SPAN> ws.Name <> "pga_list" And ws.Name <> "Results" And ws.Name <> "Results Summary" <SPAN style="color:#00007F">Then</SPAN><br>                    ws.Range("A10:D10").Copy Destination:=Sheets("Results Summary").Cells(Rows.count, "A").End(xlUp).Offset(1)<br>            <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>            <SPAN style="color:#00007F">Next</SPAN> ws<br>    <br>        Application.DisplayAlerts = <SPAN style="color:#00007F">True</SPAN><br><br>End <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

HTH,
 

bdiddy

New Member
Joined
Jan 25, 2011
Messages
11
Hi Smitty! This is very close to to what I am looking for.

What i have is this....

<TABLE style="WIDTH: 274pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=365><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; WIDTH: 65pt; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22 width=87>Player 1</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; WIDTH: 77pt; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67 width=102>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; WIDTH: 62pt; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 width=83 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 70pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 width=93>Score = 20</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>Player2</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68>Score = 20</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>Player 3</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68>Score = -14</TD></TR></TBODY></TABLE>

The issue is the #ref from the "=Sum" that is be pulled in from the earnings in the sheets that are being referenced in my loop. How do I correct this reference in my "Results" Page? Thanks!
 

bdiddy

New Member
Joined
Jan 25, 2011
Messages
11

ADVERTISEMENT

The Formula is =SUM(C3:C9) and remains static for "earnings" for all sheets.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If you trace the formula's dependents, where is the error starting?
 

bdiddy

New Member
Joined
Jan 25, 2011
Messages
11
Smitty, I think I underdand what you are asking but this is the best way I can explain what I know. On my "Results Summary" page in Example 1. beginning at F2 (see below) I have the list of players. In H2 (Player 1) I have the #REF! that refers to Example 2. Example 2 is also on my "Results Summary" page. It fills columns of data begining in A1. All player data will fill columns A, B, C and D.

As you have seen this player data is referenced from the FOR LOOP we have modified. The Range in each sheet I am tring to "reference" is the SUM from cells C3:C9 from each sheet. The to total is in C10. Hence my problem when I execute my code ws.Range("A10:D10").Copy and get my #REF! error.

Example 1.
<TABLE style="WIDTH: 309pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=411><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; WIDTH: 71pt; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22 width=94>Player 1</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; WIDTH: 76pt; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67 width=101>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; WIDTH: 86pt; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 width=115 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 76pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 width=101>Score = 20</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>Player 2</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68>Score = 20</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=22>Player 3</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl67>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f; BORDER-RIGHT: #3f3f3f 2pt double" class=xl66 align=middle>#REF!</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68>Score = -14</TD></TR></TBODY></TABLE>

Example 2.
<TABLE style="WIDTH: 309pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=411><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; WIDTH: 233pt; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75 height=21 width=310 colSpan=3>Player 1 C</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 76pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=101></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69 height=22>Player ID</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>Name</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>Purse</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 16.5pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=22>9</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Dustin Johnson </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$162,000.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 16.5pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=22>3</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Graeme McDowell </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$412,000.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=21>4</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Carl Pettersson </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$286,500.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=20>4</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Carl Pettersson </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$286,500.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=20>11</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Jason Day </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$162,000.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=20>15</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Francesco Molinari </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$107,000.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15.75pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl70 height=21>10</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67>Jim Furyk </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl68 align=right>$162,000.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c0504d; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=22>Player 1</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl73>Total Earnigs =</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl72 align=right>$1,578,000.00 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl74>Score = 20</TD></TR></TBODY></TABLE>

I hope this makes sense and helps you understand what I am trying to do. Thank you for taking the time to look at this.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,919
Messages
5,627,624
Members
416,257
Latest member
salomon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top