Spreadsheet: 131125d1322750381-daily-summary-sheet-that-autopopulates-each-day-ptyesterdaydata
Sheet: Data

Date | Position 1 | P1#
2011-10-01 00:00:00 | [NAME] | 100 |  | Pivot Table of data to the left.  Values are shown as % of Column Total.
2011-10-02 00:00:00 | [NAME] | 101 |  | Then click on Row Labels dropdown and select a single date.
2011-10-03 00:00:00 | [NAME] | 102
2011-10-04 00:00:00 | [NAME] | 103 |  | Sum of P1# | Column Labels
2011-10-05 00:00:00 | [NAME] | 104 |  | Row Labels | [NAME] | [NAME] | [NAME] | Garry | [NAME] | [NAME] | Lance | Lorenzo | Martin | [NAME] | [NAME] | Grand Total
2011-10-06 00:00:00 | [NAME] | 105 |  | 2011-10-01 00:00:00 | 0 | 0 | 0 | 0 | 0.2403846153846154 | 0.09624639076034648 | 0 | 0.2427184466019418 | 0 | 0 | 0 | 0.07396449704142012
2011-10-07 00:00:00 | [NAME] | 106 |  | 2011-10-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0.1934552454282965 | 0 | 0 | 0 | 0.3206349206349207 | 0.3247311827956989 | 0.07445759368836292
2011-10-08 00:00:00 | [NAME] | 107 |  | 2011-10-03 00:00:00 | 0 | 0.3207547169811321 | 0 | 0.3268608414239482 | 0 | 0 | 0.3247863247863248 | 0 | 0 | 0 | 0 | 0.07495069033530571
2011-10-09 00:00:00 | [NAME] | 108 |  | 2011-10-04 00:00:00 | 0.3248407643312102 | 0 | 0.3208722741433022 | 0 | 0 | 0 | 0 | 0 | 0.3268921095008052 | 0 | 0 | 0.07544378698224852
2011-10-10 00:00:00 | [NAME] | 109 |  | 2011-10-05 00:00:00 | 0 | 0 | 0 | 0 | 0.2467948717948718 | 0.1000962463907603 | 0 | 0.2475728155339806 | 0 | 0 | 0 | 0.07593688362919132
2011-10-11 00:00:00 | [NAME] | 110 |  | 2011-10-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0.1973051010587103 | 0 | 0 | 0 | 0.3333333333333333 | 0.3333333333333333 | 0.07642998027613412
2011-10-12 00:00:00 | [NAME] | 111 |  | 2011-10-07 00:00:00 | 0 | 0.3333333333333333 | 0 | 0.3333333333333333 | 0 | 0 | 0.3333333333333333 | 0 | 0 | 0 | 0 | 0.07692307692307693
2011-10-13 00:00:00 | [NAME] | 112 |  | 2011-10-08 00:00:00 | 0.3333333333333333 | 0 | 0.3333333333333333 | 0 | 0 | 0 | 0 | 0 | 0.3333333333333333 | 0 | 0 | 0.07741617357001973
2011-10-01 00:00:00 | Lorenzo | 200 |  | 2011-10-09 00:00:00 | 0 | 0 | 0 | 0 | 0.2532051282051282 | 0.1039461020211742 | 0 | 0.2524271844660194 | 0 | 0 | 0 | 0.07790927021696252
2011-10-02 00:00:00 | [NAME] | 201 |  | 2011-10-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0.2011549566891242 | 0 | 0 | 0 | 0.346031746031746 | 0.3419354838709677 | 0.07840236686390532
2011-10-03 00:00:00 | Garry | 202 |  | 2011-10-11 00:00:00 | 0 | 0.3459119496855346 | 0 | 0.3398058252427185 | 0 | 0 | 0.3418803418803419 | 0 | 0 | 0 | 0 | 0.07889546351084813
2011-10-04 00:00:00 | Martin | 203 |  | 2011-10-12 00:00:00 | 0.3418259023354565 | 0 | 0.3457943925233645 | 0 | 0 | 0 | 0 | 0 | 0.3397745571658615 | 0 | 0 | 0.07938856015779093
2011-10-05 00:00:00 | Lorenzo | 204 |  | 2011-10-13 00:00:00 | 0 | 0 | 0 | 0 | 0.2596153846153846 | 0.1077959576515881 | 0 | 0.2572815533980582 | 0 | 0 | 0 | 0.07988165680473373
2011-10-06 00:00:00 | [NAME] | 205 |  | Grand Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2011-10-07 00:00:00 | Garry | 206
2011-10-08 00:00:00 | Martin | 207
2011-10-09 00:00:00 | Lorenzo | 208 |  | I think you will need some VBA to set the Date to yesterday based on today() date.
2011-10-10 00:00:00 | [NAME] | 209
2011-10-11 00:00:00 | Garry | 210
2011-10-12 00:00:00 | Martin | 211
2011-10-13 00:00:00 | Lorenzo | 212
2011-10-01 00:00:00 | [NAME] | 150
2011-10-02 00:00:00 | [NAME] | 151
2011-10-03 00:00:00 | Lance | 152
2011-10-04 00:00:00 | [NAME] | 153
2011-10-05 00:00:00 | [NAME] | 154
2011-10-06 00:00:00 | [NAME] | 155
2011-10-07 00:00:00 | Lance | 156
2011-10-08 00:00:00 | [NAME] | 157
2011-10-09 00:00:00 | [NAME] | 158
2011-10-10 00:00:00 | [NAME] | 159
2011-10-11 00:00:00 | Lance | 160
2011-10-12 00:00:00 | [NAME] | 161
2011-10-13 00:00:00 | [NAME] | 162