Spreadsheet: 165436d1341233123-automatically-populate-data-based-on-month-auto-populate-by-current-month-test
Sheet: Sheet1

PRODUCTS | Current Month | Current Quarter |  |  | Current quarter | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | aug
02PCIOL |  |  |  |  |  | 13727 | 47040 | 73808 | 237914 | 81808 | 80705 | 57368 | 89234 | 91312 | 118361 | 108771 | 87528
ACCIOL |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15000 | 15000 | 13500
TMF1ACR |  |  |  |  |  | 7570 | 19682 | 30280 | 22710 | 43906 | 46934 | 33000 | 51750 | 60000 | 67500 | 60000 | 56250
TMF3ACR |  |  |  |  |  | 3295 | 22406 | 36904 | 9885 | 32950 | 29655 | 21088 | 32950 | 26360 | 29655 | 29655 | 14498
PHAIOL |  |  |  |  |  | 2172 | 4262 | 5934 | 3008 | 4262 | 3426 | 2590 | 3844 | 4262 | 5516 | 3426 | 2590
OTHPCI |  |  |  |  |  | 690 | 690 | 690 | 690 | 690 | 690 | 690 | 690 | 690 | 690 | 690 | 690
02MONOIOL |  |  |  |  |  | 267721 | 560572 | 595383 | 549375 | 722552 | 732274 | 630331 | 732904 | 694888 | 792318 | 735570 | 605771
TCLSIL |  |  |  |  |  | 28600 | 105160 | 102520 | 87780 | 110660 | 104500 | 80740 | 107580 | 93060 | 93720 | 83380 | 69960
TEC1ACR |  |  |  |  |  | 151728 | 298120 | 292088 | 262624 | 344984 | 344288 | 317376 | 367024 | 348000 | 405304 | 374912 | 316912
TEC3ACR |  |  |  |  |  | 52668 | 94752 | 108360 | 95256 | 138348 | 124236 | 94500 | 105840 | 76608 | 103824 | 103068 | 81144
TECTACR |  |  |  |  |  | 19600 | 34300 | 58800 | 80850 | 102900 | 132300 | 112700 | 122500 | 142100 | 154350 | 142100 | 120050
SENSAR |  |  |  |  |  | 15125 | 28240 | 33615 | 22865 | 25660 | 26950 | 25015 | 29960 | 35120 | 35120 | 32110 | 17705
02PHACO |  |  |  |  |  | 179397 | 326811 | 387100 | 237366 | 356533 | 462518 | 325993 | 374305 | 433388 | 329845 | 429837 | 353307
EQUSIG |  |  |  |  |  | 0 | 68000 | 68000 | 0 | 68000 | 68000 | 0 | 68000 | 68000 | 0 | 68000 | 68000
EQICOM |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 41000 | 0 | 0 | 0 | 0 | 0 | 0
PHAPAC |  |  |  |  |  | 131802 | 176959 | 220604 | 173141 | 218261 | 260915 | 238602 | 210320 | 257338 | 243747 | 263726 | 205072
PHATIP |  |  |  |  |  | 37665 | 68202 | 82296 | 48195 | 55242 | 75573 | 71361 | 79785 | 92340 | 67878 | 81891 | 64395
PHAOTH |  |  |  |  |  | 9930 | 13650 | 16200 | 16030 | 15030 | 17030 | 16030 | 16200 | 15710 | 18220 | 16220 | 15840
02OVD |  |  |  |  |  | 124431 | 184763 | 233328.5 | 193670.5 | 239067.5 | 230768 | 219288 | 281621 | 249610.5 | 262206 | 253149.5 | 179724.5
OVDCOH |  |  |  |  |  | 124431 | 184763 | 233328.5 | 193670.5 | 239067.5 | 230768 | 200538 | 262871 | 230860.5 | 243456 | 234399.5 | 160974.5
OVDDIS |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 18750 | 18750 | 18750 | 18750 | 18750 | 18750
02OTHCAR |  |  |  |  |  | 17505 | 31376 | 39984 | 28166 | 41652 | 53988 | 34940 | 38656 | 41514 | 40898 | 40070 | 33876
OTHSTA |  |  |  |  |  | 1155 | 3956 | 4644 | 1376 | 3612 | 1548 | 860 | 2236 | 4644 | 2408 | 860 | 516
OTHSHU |  |  |  |  |  | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100 | 5100
OTHCAR |  |  |  |  |  | 11250 | 22320 | 30240 | 21690 | 32940 | 47340 | 28980 | 31320 | 31770 | 33390 | 34110 | 28260
GRAND TOTAL |  |  |  |  |  | 602781 | 1150562 | 1329603.5 | 1246491.5 | 1441612.5 | 1560253 | 1267920 | 1516720 | 1510712.5 | 1543628 | 1567397.5 | 1260206.5
 | To automatically populate, just by updating B2 cell
 | Say if I type July in B2 cell, it should automatically populate the values from the table on the right
 | Same with the Quarter