Spreadsheet: 141432d1329260068-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: Capital Tristate Branches

Capital Tristate
Branch ID's and Locations
2011-02-01 00:00:00
# | OpCo | BranchID | Dept ID | Location | Street Address | City | State | Zip | Ph | Fax | Manager(s) | Territory | City & Branch ID
1 | Capital Tristate | KALX | KALX | ALEXANDRIA | 890 Picket Street | [NAME] | VA | 22304 | 7032539780 | 7033705738 | [NAME] | Capital
 | Capital Tristate | KANN | KANN | ANNAPOLIS | 1816 [NAME] | [NAME] | MD | 21401 | 4109192400 | 4102681303 | [NAME] | Capital
 | Capital Tristate | KASH | KASH | [NAME] | 625 N Washington Highway | Ashland | VA | 23005 | 8047982155 | 8047982126 | [NAME] | Capital
 | Capital Tristate | KBAL | KBAL | BALTIMORE ([NAME]) | 600 W Hamburg Street | Baltimore | MD | 21230 | 4107524080 | 4103328497 | [NAME] | Capital
 | Capital Tristate | KBMR | KBMR | BALTIMORE (Moravia Park) | 6667 Moravia Park Drive | Baltimore | MD | 21237 | 4104831200 | 4103255219 | [NAME] | Tristate
 | Capital Tristate | KCHA | KCHA | CHAMBERSBURG | 420 West Commerce Street | Chambersburg | PA | 17201 | 7172644631 | 7172641455 | Shane Hershey | Tristate
 | Capital Tristate | KCHV | KCHV | CHARLOTTESVILLE | 2390 Hunters Way | Charlottesville | VA | 22911 | 4342938117 | 4349792611 | [NAME] | Capital
 | Capital Tristate | KCHE | KCHE | CHESAPEAKE | 1028 Executive Boulevard | Chesapeake | VA | 23320 | 7575477222 | 7575479436 | [NAME] | Capital
 | Capital Tristate | KCTN | KCTN | CHESTERTOWN | 305 College Ave. | Chestertown | MD | 21620 | 4107781154 | 4107780731 | [NAME] | Tristate
 | Capital Tristate | KCHT | KCHT | COLONIAL HEIGHTS | 16425 [NAME]. | Colonial Heights | VA | 23834 | 8045207798 | 8045207880 | [NAME] | Tristate
 | Capital Tristate | KCOL | KCOL | COLUMBIA | 8916 Mcgaw Court | Columbia | MD | 21045 | 4109956844 | 4102905738 | [NAME] | Tristate
 | Capital Tristate | KCOM | KCOM | COMMERCIAL | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KCMB | KCMB | CUMBERLAND | 86 Wineow Street | Cumberland | MD | 21502 | 8006416869 | 3017770259 | [NAME] | Tristate
 | Capital Tristate | KFAR | KFAR | FARMVILLE | 1012-J W. 3rd Street | Farmville | MVA | 23901 |  |  | [NAME] | Capital
 | Capital Tristate | KFDK | KFDK | FREDERICK | 260 Interstate Circle | [NAME] | MD | 21704 | 3016631232 | 3016633255 | [NAME] | Capital
 | Capital Tristate | KFBG | KFBG | FREDERICKSBURG | 430 TV Drive | Fredericksburg | VA | 22408 | 5407107200 | 5407107061 | [NAME] | Capital
 | Capital Tristate | KGBG | KGBG | GAITHERSBURG | 19050 Woodfield Road | Gaithersburg | MD | 20874 | 3019214446 | 3019210674 | Gregory Deppen | Capital
 | Capital Tristate | KGET | KGET | GETTYSBURG | 828 Biglerville Road | Gettysburg | PA | 17325 | 7173346721 | 7173343121 | [NAME] | Tristate
 | Capital Tristate | KGBU | KGBU | [NAME] | 114 Roesler Road | [NAME] | MD | 21061 | 4107612870 | 4107663759 | [NAME] | Tristate
 | Capital Tristate | KGOL | KGOL | GOLDEN RING | 6905 Golden Ring Road | Baltimore | MD | 21237 | 4109180540 | 4109181713 | [NAME] | Capital
 | Capital Tristate | KGOO | KGOO | GOOCHLAND | 12925 Plaza Drive | Richmond | VA | 23233 | 8047840224 | 8047844972 | [NAME] | Capital
 | Capital Tristate | KHGN | KHGN | HAGERSTOWN (Crossdock) | 12117 Insurance Way | Hagerstown | MD | 21740 | 3017331212 | 3017902423 | Ctr: [NAME] Ops: [NAME] | Tristate
 | Capital Tristate | [NAME] | [NAME] | HANOVER | 425 East Middle Street | Hanover | PA | 17331 | 7176327773 | 7176329683 | [NAME] | Tristate
 | Capital Tristate | KHDG | KHDG | HAVRE DE GRACE | 1846 Pulaski Hwy | Havre De Grace | MD | 21078 | 4109395880 |  | [NAME] | Tristate
 | Capital Tristate | KLST | KLST | LANCASTER | 1812A Olde Homestead Lane | Lancaster | PA | 17601 | 7173946881 | 7173935799 | [NAME] | Tristate
 | Capital Tristate | KMAN | KMAN | MANASSAS | 7239 Gateway Court | Manassas | VA | 20109 | 7033616028 | 7032570487 | [NAME] | Capital
 | Capital Tristate | KMTN | KMTN | MARTINSBURG | 48 [NAME] | Martinsburg | WV | 25405 | 3042631212 | 3042634806 | [NAME] | Tristate
 | Capital Tristate | KMCC | KMCC | MCCONNELLSBURG | 22438 Great Cove Rd., Ste 108 | McConnellsburg | PA | 17233 | 7179870183 | 7179870186 | [NAME] | Tristate
 | Capital Tristate | KMEC | KMEC | MECHANICSBURG | 701 West Simpson Street | Mechanicsburg | PA | 17055 | 7177663287 | 7177661586 | [NAME] | Tristate
 | Capital Tristate | KSKI | KSKI | MOSELEY ([NAME]) | 17211 Hull Street Road | Moseley | VA | 23120 | 8047392743 | 8047397247 | [NAME] | Capital
 | Capital Tristate | KOCE | KOCE | OCEAN PINES | 11070 Cathell Rd. | Berlin | MD | 21811 | 4102080800 | 4102080824 | [NAME] | Tristate
 | Capital Tristate | KRIC | KRIC | RICHMOND | 1901 N Hamilton Street | Richmond | VA | 23230 | 8043558003 | 8043594055 | [NAME] | Capital
 | Capital Tristate | KSAL | KSAL | SALISBURY | 1774 [NAME] | Salisbury | MD | 21801 | 4105461221 | 4105464230 | [NAME] | Tristate
 | Capital Tristate | KSTE | KSTE | STERLING | 45969 Nokes Boulevard, Suite 155 | Sterling | VA | 20166 | 7034445080 | 7034445279 | [NAME] | Capital
 | Capital Tristate | KSUF | KSUF | SUFFOLK | 6950-B Harbour View Blvd | Suffolk | VA | 23435 | 7574843816 | 7574842607 | [NAME] | Capital
 | Capital Tristate | KSWE | KSWE | SWEDESBORO | 403 Haron Dr. Suite D | Swedesboro | NJ | 08085 | 8565421453 | 8564671844 | [NAME] | Tristate
 | Capital Tristate | KTIM | KTIM | TIMONIUM | 14 West Aylesbury Road | Timonium | MD | 21093 | 4102527020 | 4102528740 | [NAME] | Tristate
 | Capital Tristate | KCDC | KCDC | UPPER MARLBORO (CDC) | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KCOR | KCOR | UPPER MARLBORO (Corporate) | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KUPP | KUPP | UPPER MARLBORO (Counter) | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KPJH | KPJH | UPPER MARLBORO (Project Homes) | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KWES | KWES | WESTMINSTER | 1101-A Business Pkway South | Westminster | MD | 21157 | 4108483050 | 4108760523 | [NAME] | Tristate
 | Capital Tristate | KEMS | KEMS | WHITE MARSH (Energy Maint) | 8511 Pepco Place | Upper Marlboro | MD | 20772 | 3019096500 | 3017358074 | [NAME] | Capital
 | Capital Tristate | KWHM | KWHM | WHITE MARSH | 8009 Corporate Drive | White Marsh | MD | 21236 | [PHONE] | 4104833031 | [NAME] | Tristate
 | Capital Tristate | KWHP | KWHP | WHITE PLAINS | 4382 [NAME] | White Plains | MD | 20695 | 3018853232 | 3018853699 | [NAME] | Capital
 | Capital Tristate | KWIL | KWIL | WILLIAMSBURG | 1637 [NAME] | Williamsburg | VA | 23185 | 7572531440 | 7572538837 | [NAME] | Capital
 | Capital Tristate | KWCR | KWCR | WINCHESTER | 2740 S. Pleasant Valley Road | Winchester | VA | 22601 | 5406621769 | 5406650364 | [NAME] | Tristate
 | Capital Tristate | KYOR | KYOR | YORK | 1150 [NAME] | York | PA | 17402 | 7177551455 | 7177552710 | Ctr: Tyke Markle / Ops: Jen Kashner | Tristate