I work in sales and cover a large territory. To manage the territory, I break it up into "Zones" (i.e. Philly / Pittsburgh / etc). My organization provides an excel file with every company I call on and a litany of sales information - this is Sheet 1 of my excel workbook. I've already inserted an extra column on Sheet 1 and labeled "Zone" to identify where each company will fall into.
To simplify the management within each zone, I want separate Sheets for each of the named zones. What I'd like to know is what formula I can enter on the sheet labeled "Philly" such that "if" the Zone Column on Sheet 1 = "Philly", then the entire row will map to the sheet labeled Philly.
Further, some zones have sub-zones (i.e Central PA) and so I'd like one sheet to search for any Sheet 1 Zone equal to Harrisburg, State College, Scranton, etc and bring them all to the one sheet named Central PA in the same fashion as above.
Thanks for your help!