Choose a missing state. Check dirty laundry and see if the state exists. If not, add it.

Begin by Googling [State Name] School Regions

Choose an official region map with counties and tag it in delicious

Open the master file [State Code] Census Source Data.xlxs

Goto the School Regions tab

Export the State’s School Regions using the “SE Export Regions” query. Be careful to change the state code before exporting. Save the file as “[State Code] Export Regions.xlsx” in Box in the state’s “Schools” folder.

Paste the exported regions into the “School Regions” tab of the state’s census data file (replace any region data that may exist).

In the “School Regions” tab, create the named range “SchoolRegionsPicklist” by selecting A2:Alast row of data by clicking Formulas à Name Manager à New.

In the “School Regions” tab, create the named range “SchoolRegionsVlookup” by selecting A2:Clast row of data.