1.  Create a nowWorksheet named: ObjectCodes

2.  Filter Column K on Expense only.

3.  Copy L2:N##

4.  Paste Special Values only in ObjectCode sheet beginning in A2

5.  Delete Column B

6.  Insert 1 column to the left of A

7.  Name the Columns: LocMunID, LocCode, LocName

8.  Hightlight the 3 columns and sort by LocCode

9.  Manually check LocName and remove dupliactes by eliminiating fuzzy names so there are no duplicate Code Numbers.

10. Populate column A with the liocal Unot MunID

11. Import into MySQL c_luobjectcodes.