Spreadsheet: 785450d1656424645-have-cell-change-values-from-same-cell-different-sheet-based-on-drop-down-selection-weekly-report-trend-chart-example-
Sheet: Overall Customer Stats

 | Total Estimates
 | OVERALL TOTALS | CONVERTED ESTIMATES (CUSTOMER)'!C4
 | NAME | 2022-02-24 00:00:00 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | 2022-03-17 00:00:00 | 2022-03-24 00:00:00 | 2022-03-31 00:00:00 | 2022-04-07 00:00:00 | 2022-04-14 00:00:00 | 2022-04-21 00:00:00 | 2022-04-28 00:00:00 | 2022-05-05 00:00:00 | 2022-05-12 00:00:00 | 2022-05-19 00:00:00 | 2022-05-26 00:00:00
 | Accent Lighting, Inc
 | Advance Electrical - Chicago IL
 | All Metro Electrical Distributors
 | Anixter Power Solutions - Charlotte, NC
 | Atlanta Electrical Distributors
 | BC Lighting Group
 | Bell & McCoy Alabama
 | Bell & McCoy Austin
 | Bell & McCoy Farmers Branch
 | Bell & McCoy Houston
 | Bell & McCoy Little Rock, AR
 | Bell & McCoy Louisiana
 | Bell & McCoy Mississippi
 | Bell & McCoy Oklahoma
 | Bell & McCoy San Antonio
 | Border States Industries - IUO
 | Border States Industries - IUO : Border States Industries - Charlotte, NC
 | [NAME]
 | [NAME] : Bliss Lighting
 | California Electric Supply
 | California Lighting Sales
 | California Lighting Sales : Commerce Lighting Supply, Inc
 | Cantlon Lighting
 | Capital Electric - Charlotte, NC
 | Carols Lighting
 | Carr-Trumbull Lumber
 | CBMC Lighting Solutions
 | CED - IUO : 3E - Lincoln, NE
 | CED - IUO : All Phase Electric - Glenwood Springs CO
 | CED - IUO : All-Phase Electric - Oxnard, CA
 | CED - IUO : CED - Corpus Christi
 | CED - IUO : CED - Dallas, TX
 | CED - IUO : CED - Erlanger, KY
 | CED - IUO : CED - Euless, TX
 | CED - IUO : CED - Fort Worth, TX
 | CED - IUO : CED - Houston, TX Greens Pkwy
 | CED - IUO : CED - Orange, CA
 | CED - IUO : CED - Pflugerville 0234, TX
 | CED - IUO : CED - Salt Lake City, UT
 | CED - IUO : CED - Wilson, NC
 | CED - IUO : Electrical Engineering & Equipment - IUO
 | Champions Lighting
 | City Electric Supply - IUO : CES - Nashville, TN North
 | City Electric Supply - IUO : City Electric Supply - Brenham, TX
 | Coastal Lighting and Supply
 | Colonial Electric Supply Co.
 | Complete Electrical Installations, Inc.
 | Cooper Electric Supply
 | [NAME]
 | Courtesy Electric Wholesale
 | CR Lighting
 | Crawford Electric - Houston, TX
 | Crawford Electric - Irving, TX
 | Crescent Lighting Solutions
 | Crest Lighting Co.
 | [NAME] #1021
 | Dealers Electrical - IUO : Dealers Electrical - Houston, TX
 | Decker Electric
 | Distinctive Solutions, Inc
 | Doeren Sales and Associates
 | Dominion Electric Supply
 | E2I Solutions
 | Eckart LLC
 | Edges Electrical Group, LLC - San Leandro, CA
 | Electric Supply Center
 | Electric Supply Inc
 | Electrical Supply of Milford
 | Electrical [NAME]
 | Electrical Wholesalers - Newington, NH
 | Electrical Wholesalers - Woonsocket, RI
 | Ellen Lighting & Hardware
 | Elliott Electric - IUO : Elliott Electric - Conway, AR
 | Elliott Electric - IUO : [NAME], TX #49 (RDC)
 | EMSCO Electric Supply - Oklahoma City, OK
 | Exclusive Energy & Electric
 | Expressive Lighting
 | Facility Solutions Group - IUO : FSG - MDC South Irving, TX
 | Facility Solutions Group - IUO : FSG - NY, NY
 | Facility Solutions Group - IUO : FSG - Shawnee, KS
 | Facility Solutions Group - IUO : FSG - Steadmont Houston, TX
 | Facility Solutions Group - IUO : FSG - Walnut Hill Dallas, TX
 | Fadecci Architectural Lighting
 | Family (Ship to TX)
 | Federated Lighting of Virginia
 | Feldman Brothers
 | Ferguson - IUO : Ferguson - Ashville, NC
 | Ferguson - IUO : Ferguson - Austin, TX
 | Ferguson - IUO : Ferguson - Charlotte, NC #34
 | Ferguson - IUO : Ferguson - Ft Lauderdale, FL
 | Ferguson - IUO : Ferguson - Greensboro, NC
 | Ferguson - IUO : Ferguson - Houston, TX Richmond Ave
 | Ferguson - IUO : Ferguson - Jacksonville, FL
 | Ferguson - IUO : Ferguson - Nashville, TN
 | Ferguson - IUO : Ferguson - Sacramento, CA
 | First Source Electrical
 | Fixtur-World, Inc
 | Form Lighting and Controls
 | Fort Worth Lighting
 | Friends (Ship to TX)
 | Gemini Cut Glass Company Inc
 | Graybar - IUO
 | Graybar - IUO : Graybar - Charlotte, NC
 | Graybar - IUO : Graybar - Edison, NJ
 | Graybar - IUO : Graybar - Fort Worth, Dallas, TX
 | Graybar - IUO : Graybar - Houston, TX
 | Graybar - IUO : Graybar - Naples, FL
 | Graybar - IUO : Graybar - Pome Portland, ME
 | Graybar - IUO : Graybar - Portland, OR
 | Green Electrical Solutions
 | Hays Electrical Services Inc.
 | Hermitage Electric Supply
 | High Tech Applications
 | Hill Country Electric - Austin, TX
 | Home Makeover Expo - Katy, TX
 | Illumination Systems
 | Interiors by [NAME] (Space by Rbi)
 | Jackson Lighting Supply
 | [NAME]
 | [NAME]
 | Just Led + Lights
 | JW Sales
 | Kenclaire West Electrical
 | Kendall Electric - IUO : Kendall Electric - Wabash, IN
 | Kendall/Heaton Associates Inc.
 | Kirby Risk Electrical Supply
 | KTR Associates
 | Langlais Group
 | LEDI Internal Use Only
 | Legend Lighting
 | Lido Lighting - Hauppauge, NY
 | LIGHT Company - Houston, TX
 | Lighting Concepts
 | Lighting Inc - IUO- Inactive  -CONTACT REP : Lighting Inc - Houston, TX Gulf Fwy
 | Lights Fantastic Fleco - IUO
 | Lights Fantastic Fleco - IUO : [NAME], TX
 | Lights Fantastic Fleco - IUO : [NAME] (TX Fluor)
 | Lights Fantastic Fleco - IUO : [NAME], TX
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Houston, TX
 | Lights Fantastic Fleco - IUO : Lights Fantastic Pro - Lewisville, TX
 | Lights Fantastic Pro - Dallas, TX
 | Locke Supply Co - Oklahoma City, OK
 | Locke Supply Co., - Richmond, VA
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Austin
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Dallas, TX
 | Lonestar Electric Supply - IUO : Lonestar Electric Supply - Houston
 | Luminous Trends
 | Lux Lighting Design - Belmont, MA
 | M&M - IUO
 | M&M - IUO : M&M Lighting - Direct
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc- TX
 | Maldon Cabinetry - IUO : Maldon Cabinetry, Inc. CT ([NAME])
 | Marsh Sales
 | Mayer Electric Supply - Charlotte, NC
 | Meletio Lighting - Dolan Northwest - Resi
 | Metro Electric Supply
 | Mike's Lighting & Cabinet Center
 | MSRP
 | No Limit Lighting Sales
 | North Coast Electric - IUO : North Coast Electric - Bellevue, WA
 | North Coast Electric - IUO : North Coast Electric - Kent, WA
 | North Coast Electric - IUO : North Coast Electric - Seattle, WA
 | Omega Construction & Wine Rooms
 | ParamontEO
 | PDI Plumbing Distributors Inc
 | Platt Electric Supply
 | Premier Technology Group
 | [NAME]
 | [NAME]
 | Resource Lighting & Controls
 | Rexel - IUO : Rexel - Asheville, NC
 | Rexel - IUO : [NAME], TX
 | Rexel - IUO : [NAME], TX
 | Rexel - IUO : [NAME], WY
 | Rexel - IUO : Rexel - Sacramento, CA
 | Reynolds Company - Houston, TX
 | [NAME]
 | [NAME]
 | Rockingham Electrical Supply - IUO : Rockingham Electrical Supply - Newington
 | [NAME], LLC
 | South Dade Lighting
 | Southeast Florida Lighting
 | Springfield Electric - IUO : Springfield Electric - Springfield, IL
 | State Electric Supply - IUO
 | State Electric Supply - IUO : State Electric Supply Company - Huntington, WV
 | State Electric Supply - IUO : State Electric Supply Company - Raleigh, NC
 | [NAME]
 | [NAME]
 | Summit Electric Supply - Irving, TX
 | The Armored Frog
 | The Light House Gallery
 | [NAME]
 | Turtle & Hughes - IUO
 | United Electric Supply - Langhorne, PA
 | Villa Lighting
 | Walters Wholesale Electric
 | Walters Wholesale Electric - Costa Mesa, CA
 | WESCO  Distribution - Kingsport, TN
 | WESCO Distribution - CO
 | WESCO Distribution - IL
 | WESCO Distribution - TN
 | Wholesale Electric Supply Co. of Houston Inc. - IUO : Wholesale Electric - Houston, TX
 | [NAME]
 | Wilson Lighting - IUO : Wilson Lighting - Naples, FL
 | Wilson Lighting - IUO : WIlson Lighting-Clayton
 | [NAME] : Broken Arrow Electric
 | World Electric Supply