1.  Open Census Source Excel file for the state

2.  Navigate to CitiesFormulas Tab

3.  Make sure Column “Y” reads StateName – if not insert a new column Y and name it StateName

4.  Open National Census File: Munetrix Nationwide Clients/All State Maps/Census Data (2007).xlsx

5.  Navigate to State tab

6.  Find first row where Type (Column C) is 2

7.  Copy Columns A – Z including Types 2 & 3

8.  Paste Special Values Only in Cell Y2 of the State’s Census Source File

9.  Select A2:X2 and Copy

10. Paste into A3 to last row of data

11. Get master list of Counties from MySQL with MunID by exporting the saved query MU Export County State Expansion

12. Save this as an Excel file

13. Paste into CountyData tab

14. Select A2:C[Last Row] then Formulas à Name Manager à New and type CountyVlookup

15. In D2 enter the formula: =VLOOKUP(E2,CountyVlookup,3,FALSE)

16. Copy this formula to the last row

17. Do Control-Home then Control-Shift-End to see if the last row of data contains blank rows