Spreadsheet: 677380d1589323237-conditional-drop-down-auto-fill-option-is-this-possible-marcscompetitors-eba
Sheet: Source Data Tab

Technology |  |  | Service Area to be used in Drop Down |  | For: Pneumatic (incl FCD) Industrial HYD Mobile HYD Truck HYD Connector (Fluid Power) Connector ([NAME]) | Service Area | Trade Areas |  | For: EM/SSD IGFG Filtration Instrumentation Transair | Province | Trade Areas
Logic |  |  | Alaska | 010 |  | Vancouver | 710, 711 |  |  | BC (incl Yukon, NWT) | 710 - 715, 730, 731
 |  |  | California | 054, 055 |  | Interior/Northern BC | 712, 714, 730, 731 |  |  | Alberta | 700 - 706
 |  |  | Colorado | 070, 071, 072, 073 |  | Southern Alberta | 700, 701, 702, 704, 713 |  |  | Saskatchewan | 790 - 793
 |  |  | Hawaii | 148 |  | Northern Alberta (705/706) | 705, 706 |  |  | [NAME] ([NAME]) | 720, 759, 764
 |  |  | Idaho | 150, 151, 152, 153 |  | Northern Alberta (703/715) | 703, 715 |  |  | Ontario | 734 - 739, 743 - 757, 760 - 763, 765 - 767, 769
 |  |  | Montana | 360, 361, 362, 363 |  | Northern Alberta (Truck) | 703, 705, 706, 715 |  |  | Quebec (incl Ottawa area) | 740 - 742, 758, 768, 770 - 779, 783, 788
 |  |  | North Dakota | 472, 473 |  | Saskatchewan | 790, 791, 792, 793 |  |  | Atlantic Canada | 780 - 782, 784 - 787
 |  |  | Oregon | 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527 |  | Manitoba | 720, 759, 764 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  | Utah | 620 |  | Windsor | 751, 752, 769 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  | Washington | 637, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659 |  | London | 747, 750, 753, 761, 763, 765 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  | Wyoming | 690, 691, 692, 693, 694, 695, 696 |  | Tri City | 734, 748, 749 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | [NAME] | 744, 746, 762 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | GTA | 745, 755, 760, 766 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Eastern Ontario | 736, 743, 756, 757, 767 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Northern Ontario | 735, 737, 738, 739, 754 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Montreal | 740, 741, 742, 758, 768, 770, 773, 774, 775 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Quebec City | 771, 776, 777, 779 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Chicoutimi | 772, 778, 783, 788 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Atlantic Canada | 780,781,782,784,785,786,787 |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Select a Service Area from the Drop Down Menu | Select a Service Area |  |  | Select a Province from the Drop Down Menu | Select a Province
 |  |  |  |  |  | Select a Province from the Drop Down Menu | Select a Service Area |  |  | Select a Service Area from the Drop Down Menu | Select a Province
Current Fiscal Year: |  |  | FY20 |  |  |  | Instructions:
Technology: |  |  | Fluid Connectors |  | File Version: Revision 19 Updated Feb 21 2020 |  | (1) From OBI, select "Ad Hoc"
Service Area/ Province Name: |  |  | Wyoming |  |  |  | (2) Select the appropriate Territory Number      Ex.  Territory for Ind Hyd vs Mob Hyd
Trade Areas: |  |  |  |  |  |  | (2A) If your Territory Number includes Sales for other Technologies, then you will need to further refine your search by Product Division &/or Marketing Product (Code-Category). Ex. If Connector [NAME] and [NAME] are in same Territory Number
Data To Be Used:
Parker Sales |  | Total
Parker Sales |  | Total |  |  |  |  | (3) Select the appropriate Sold-To Trade Area(s)      (as shown in cell [NAME] on the left of this page)
 |  |  |  |  |  |  | (4) Click Apply
 |  |  |  |  |  |  | Note #1:  you can save your OBI search for future use * Click Page Options (symbol of 3 lines next to question mark in top right corner) * Select "Save Current Customization" * Name your custom report and Click "OK"  Note #2: To access your custom report  * Click Page Options (symbol of 3 lines next to question mark in top right corner) * Select "Apply Saved Customizations" * Click on the name of your custom report from the list  Note #3: OBI tends to be slower the first few days following a month end close.  Month end occurs on approx. the 10th working day of the month.  I suggest you wait until the 12th/13th working day of the month to run custom OBI reports as they tend to run faster the further away from Month End Close.
 |  |  | ENTER Data in Grey Shaded
 |  |  | Area.  This Data is carried
 |  |  | Throughout the Market
 |  |  | Share Template.