Spreadsheet: 181155d1347948902-need-to-populate-cells-based-on-other-cell-entry-options-daily-action-plans-appleseed-
Sheet: Projected LY Sales

JAN | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-01-01 00:00:00 | 1 | 1001 |  | 2012-01-11 00:00:00 | 11 | 111 |  | 2012-01-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 31 | 131
FEB | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-02-01 00:00:00 | 32 | 101 |  | 2012-02-11 00:00:00 | 42 | 111 |  | 2012-02-21 00:00:00 | 52 | 121
 | 33 | 102 |  |  | 43 | 112 |  |  | 53 | 122
 | 34 | 103 |  |  | 44 | 113 |  |  | 54 | 123
 | 35 | 104 |  |  | 45 | 114 |  |  | 55 | 124
 | 36 | 105 |  |  | 46 | 115 |  |  | 56 | 125
 | 37 | 106 |  |  | 47 | 116 |  |  | 57 | 126
 | 38 | 107 |  |  | 48 | 117 |  |  | 58 | 127
 | 39 | 108 |  |  | 49 | 118 |  |  | 59 | 128
 | 40 | 109 |  |  | 50 | 119 |  |  | 60 | 129
 | 41 | 110 |  |  | 51 | 120
MAR | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-03-01 00:00:00 | 61 | 101 |  | 2012-03-11 00:00:00 | 71 | 111 |  | 2012-03-21 00:00:00 | 21 | 121
 | 62 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 63 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 64 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 65 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 66 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 67 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 68 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 69 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 70 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 31 | 131
APR | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-04-01 00:00:00 | 1 | 101 |  | 2012-04-11 00:00:00 | 11 | 111 |  | 2012-04-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
MAY | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-05-01 00:00:00 | 1 | 101 |  | 2012-05-11 00:00:00 | 11 | 111 |  | 2012-05-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 30 | 130
JUN | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-06-01 00:00:00 | 1 | 101 |  | 2012-06-11 00:00:00 | 11 | 111 |  | 2012-06-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
JUL | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-07-01 00:00:00 | 1 | 101 |  | 2012-07-11 00:00:00 | 11 | 111 |  | 2012-07-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 30 | 130
AUG | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-08-01 00:00:00 | 1 | 101 |  | 2012-08-11 00:00:00 | 11 | 111 |  | 2012-08-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 30 | 130
SEP | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-09-01 00:00:00 | 1 | 101 |  | 2012-09-11 00:00:00 | 11 | 111 |  | 2012-09-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
OCT | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-10-01 00:00:00 | 1 | 101 |  | 2012-10-11 00:00:00 | 11 | 111 |  | 2012-10-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 30 | 130
NOV | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-11-01 00:00:00 | 1 | 101 |  | 2012-11-11 00:00:00 | 11 | 111 |  | 2012-11-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
DEC | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES |  |  | LAST YR SALES | PROJECTED SALES
2012-12-01 00:00:00 | 1 | 101 |  | 2012-12-11 00:00:00 | 11 | 111 |  | 2012-12-21 00:00:00 | 21 | 121
 | 2 | 102 |  |  | 12 | 112 |  |  | 22 | 122
 | 3 | 103 |  |  | 13 | 113 |  |  | 23 | 123
 | 4 | 104 |  |  | 14 | 114 |  |  | 24 | 124
 | 5 | 105 |  |  | 15 | 115 |  |  | 25 | 125
 | 6 | 106 |  |  | 16 | 116 |  |  | 26 | 126
 | 7 | 107 |  |  | 17 | 117 |  |  | 27 | 127
 | 8 | 108 |  |  | 18 | 118 |  |  | 28 | 128
 | 9 | 109 |  |  | 19 | 119 |  |  | 29 | 129
 | 10 | 110 |  |  | 20 | 120 |  |  | 30 | 130
 |  |  |  |  |  |  |  |  | 30 | 130