Spreadsheet: 35134d1232648398-getting-excel-to-increase-the-range-each-month-export-sales-comparisons-suggestion
Sheet: Summary

 | Q1 |  |  |  | Q2 |  |  |  | Q3 |  |  |  | Q4 |  |  |  | YTD VS LAST YR (FULL) |  |  |  | YTD VERSUS FULL YR BUDGET |  |  |  | YTD VERSUS YTD BUDGET
 | £ | £ | £ | Prev. | £ | £ | £ | Prev. | £ | £ | £ | Prev. | £ | £ | £ | Prev. | Year | Prev. | £ |  | Year | £ | £ |  | Year | Previous | £
 | Q1 | Q1 | Budget | Year | Q2 | Q2 | Budget | Year | Q3 | Q3 | Budget | Year | Q4 | Q4 | Budget | Year | to date | YTD | YTD | %age | to date | Annual | YTD | %age | to date | Year | [NAME] | %age
 | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Budget | [NAME] | Actual | Actual | Actual | [NAME] | [NAME] | Actual | Budget | [NAME] | [NAME] | Actual | to date |  | [NAME]
Africa Total | 12296 | 9000 | 3296.000000000001 | 11324 | 3796 | 9000 | -5204 | 7960 | 14682 | 8000 | 6682 | 3197 | 0 | 9000 | -9000 | 7091 | 30774 | 29572 | 1202 | 4.064655755444339 | 30774 | 35000 | 4226 | -12.07428571428571 | 30774 | 26000 | 4774 | 18.36153846153846
Oceania | 13578 | 15428.57142857143 | -1850.571428571429 | 20521 | 15282 | 15428.57142857143 | -146.5714285714294 | 18079 | 4371 | 13714.28571428571 | -9343.285714285714 | 11505 | 0 | 15428.57142857143 | -15428.57142857143 | 17094 | 33231 | 67199 | -33968 | -50.54837125552464 | 33231 | 60000 | -26769 | -44.615 | 33231 | 44571.42857142858 | -11340.42857142858 | -25.44326923076924
Europe | 179195 | 197228.5714285714 | -18033.57142857143 | 137221 | 173911 | 197228.5714285714 | -23317.57142857143 | 185319 | 164412 | 175314.2857142857 | -10902.28571428572 | 158156 | 0 | 197228.5714285714 | -197228.5714285714 | 205336 | 517518 | 686032 | -168514 | -24.56357720922639 | 517518 | 767000.0000000001 | -249482.0000000001 | -32.52698826597133 | 517518 | 569771.4285714284 | -52253.42857142841 | -9.170945742653668
Far East | 39967 | 51171.42857142857 | -11204.42857142857 | 58281 | 66332 | 51171.42857142857 | 15160.57142857143 | 35285 | 23494 | 45485.71428571428 | -21991.71428571428 | 48675 | 0 | 51171.42857142857 | -51171.42857142857 | 40182 | 129793 | 182423 | -52630 | -28.85052871622548 | 129793 | 199000 | -69207 | -34.77738693467337 | 129793 | 147828.5714285714 | -18035.57142857139 | -12.20032856590643
Middle East | 7689 | 34714.28571428571 | -27025.28571428571 | 36783 | 33194 | 34714.28571428571 | -1520.285714285711 | 26510 | 26646 | 30857.14285714286 | -4211.142857142855 | 27707 | 0 | 34714.28571428571 | -34714.28571428571 | 41710 | 67529 | 132710 | -65181 | -49.1153643282345 | 67529 | 135000 | -67471 | -49.97851851851852 | 67529 | 100000 | -32471.00000000001 | -32.47100000000001
N America | 40960 | 54000 | -13040 | 43913 | 71941 | 54000 | 17941 | 53748 | 61620 | 48000 | 13620 | 50829 | 0 | 54000 | -54000 | 77294 | 174521 | 225784 | -51263 | -0.2270444318463664 | 174521 | 210000 | -35479 | -16.8947619047619 | 174521 | 156000 | 18521.00000000003 | 11.87243589743592
S America | 1997 | 1028.571428571428 | 968.4285714285716 | 647 | 59 | 1028.571428571428 | -969.5714285714284 | 647 | 0 | 914.2857142857142 | -914.2857142857142 | 1673 | 0 | 1028.571428571428 | -1028.571428571428 | 1132 | 2056 | 4099 | -2043 | -0.4984142473774091 | 2056 | 4000 | -1944 | -0.4859999999999999 | 2056 | 2971.428571428571 | -915.4285714285706 | -0.3080769230769229
Total | 295682 | 362571.4285714286 | -66889.42857142858 | 308690 | 364515 | 362571.4285714286 | 1943.571428571432 | 327548 | 295225 | 322285.7142857143 | -27060.71428571428 | 301742 | 0 | 362571.4285714286 | -362571.4285714286 | 389839 | 955422 | 1327819 | -372397 | -28.04576527373083 | 955422 | 1410000 | -454578 | -32.23957446808511 | 955422 | 1047142.857142857 | -91720.85714285693 | -8.759154160982245