Hi all,
I need to split a master workbook into separate workbooks (or worksheets if that's easier because I have a macro to split worksheets into separate spreadsheets) based on unique values in a column. Basically I am to split a rather large excel file with 2 sheets (each with many organizations and respected data and headers. Both sheet 1 and 2 will have very similar data based on organizations which the column A represents with a unique identifier by which I am to split the spreadsheet. I am attaching a sample of my excel speadsheet:
Here the macro that I am using, but it only works for one of the worksheets and it creates a bunch of new worksheets based on the unique cell data in column A starting with the 12th row (the prior rows are headers).
Is it possible to have it do the same for both of the worksheets? Meaning, create a new spreadsheet with its name as each unique cell in column A with 2 worksheets (each with data based on the same unique column A values (e.g. AK-500. AK-501, etc)
Am I making any sense? I know it must sound confusing. I got thrown this task with 48 hours to do it in and if the macro does not work, I'll have to do everything manually (a la cut/paste
).
I would greatly appreciate any insight into this.ray:
Dmitriy.
I need to split a master workbook into separate workbooks (or worksheets if that's easier because I have a macro to split worksheets into separate spreadsheets) based on unique values in a column. Basically I am to split a rather large excel file with 2 sheets (each with many organizations and respected data and headers. Both sheet 1 and 2 will have very similar data based on organizations which the column A represents with a unique identifier by which I am to split the spreadsheet. I am attaching a sample of my excel speadsheet:
Code:
<table border="0" cellpadding="0" cellspacing="0" width="10296"><col style="width:99pt" span="78" width="132"> <tbody><tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl67" style="width:99pt" width="132">Field Office:</td> <td class="xl82" style="border-left:none;width:99pt" width="132">Anchorage</td> <td class="xl80" style="width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td colspan="8" rowspan="7" class="xl104" style="border-right:1.0pt solid black; border-bottom:1.0pt solid black;width:792pt" width="1056">General Instructions: This report includes the CoC's Review HHN amount, Review PPRN amount, and whether or not the CoC has decided to use the HHN reallocation process. This report also compares data from the Review GIW saved on the J drive to the data submitted in the Exhibit 2 applications, and determines if the data sets are the same. These compared data sets are populated in the gray shaded columns. Each Desk Officer is required to review the data where the GIW and Exhibit 2 are NOT reported as the same. For these discrepancies, the correct information must be entered in the "DO Review" column, and recorded in e-snaps, using the Desk Officer renewal assessment form. The assessment form is NOT to be used for data sets that are correctly reported here. The completed report must be saved on the J drive at: J:/SNAPS/Reports 2011/Review Discrepancy Report, and will be used to help announce renewal awards.
Note: Project name, EIN data, and Total Grant Amount are compared here for informational purposes only. These data sets cannot be changed by the Desk Officers. </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl69" style="border-top:none;width:99pt" width="132">CoC Number:</td> <td class="xl82" style="border-top:none;border-left:none;width:99pt" width="132">AK-500</td> <td class="xl80" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl69" style="border-top:none;width:99pt" width="132">CoC Name:</td> <td class="xl82" style="border-top:none;border-left:none;width:99pt" width="132">Anchorage CoC</td> <td class="xl80" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl71" style="border-top:none;width:99pt" width="132">HHN Amount:</td> <td class="xl101" style="border-top:none;border-left:none;width:99pt" width="132">$2,146,312.00</td> <td class="xl80" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl71" style="width:99pt" width="132">PPRN Amount:</td> <td class="xl101" style="border-top:none;border-left:none;width:99pt" width="132">$661,540.00</td> <td class="xl80" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="mso-height-source:userset;height:17.25pt" height="23"> <td class="xl68" style="height:17.25pt;width:99pt" height="23" width="132">
</td> <td class="xl71" style="width:99pt" width="132">CoC HHN Status:</td> <td class="xl82" style="border-top:none;border-left:none;width:99pt" width="132">HHN</td> <td class="xl80" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="height:16.5pt" height="22"> <td class="xl68" style="height:16.5pt;width:99pt" height="22" width="132">
</td> <td class="xl100" style="width:99pt" width="132">CoC Reallocating:</td> <td class="xl83" style="border-top:none;border-left:none;width:99pt" width="132"> </td> <td class="xl81" style="border-top:none;width:99pt" width="132"> </td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> <td class="xl68" style="width:99pt" width="132">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl70" style="height:15.0pt" height="20">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl85">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl88" style="height:15.0pt" height="20"> </td> <td class="xl87" style="border-left:none">SAME PROJECT NUMBER ON EXHIBIT 2 AND GIW</td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl87" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> <td class="xl88" style="border-left:none"> </td> </tr> <tr style="mso-outline-level:1;height:15.75pt" height="21"> <td class="xl70" style="height:15.75pt" height="21">
</td> <td colspan="2" class="xl113" style="border-right:1.0pt solid black; width:198pt" width="264">Project Number</td> <td colspan="4" class="xl102" style="border-right:1.0pt solid black;border-left: none">Project Name</td> <td colspan="4" class="xl113" style="border-right:1.0pt solid black; border-left:none;width:396pt" width="528">Component</td> <td colspan="4" class="xl113" style="border-right:1.0pt solid black; border-left:none;width:396pt" width="528">Grantee/Applicant Name</td> <td colspan="4" class="xl102" style="border-right:1.0pt solid black;border-left: none">EIN/TIN</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black;border-left: none">Number of SRO Units</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black;border-left: none">Number of 0 BR Units</td> <td colspan="3" class="xl116" style="border-left:none">Number of 1 BR Units</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black">Number of 2 BR Units</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black;border-left: none">Number of 3 BR Units</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black;border-left: none">Number of 4 BR Units</td> <td colspan="4" class="xl116" style="border-right:1.0pt solid black;border-left: none">Number of 5 BR Units</td> <td colspan="4" class="xl102" style="border-right:1.0pt solid black;border-left: none">Number of 6+ BR Units</td> <td colspan="4" class="xl102" style="border-right:1.0pt solid black;border-left: none">Total Units Eligible for Renewal</td> <td colspan="4" class="xl120" style="border-right:1.0pt solid black; border-left:none;width:396pt" width="528">Total Grant Amount </td> <td class="xl86" style="width:99pt" width="132">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> <td class="xl70">
</td> </tr> <tr style="mso-outline-level:1;height:15.75pt" height="21"> <td class="xl79" style="height:15.75pt" height="21"> </td> <td class="xl74">GIW</td> <td class="xl75" style="border-left:none">Exhibit 2</td> <td class="xl89" style="border-top:none">GIW</td> <td class="xl89" style="border-top:none">Exhibit 2</td> <td class="xl90" style="border-top:none">Same?</td> <td class="xl91" style="border-top:none">DO Review</td> <td class="xl77" style="border-left:none">GIW</td> <td class="xl74">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl76" style="border-left:none">DO Review</td> <td class="xl77">GIW</td> <td class="xl74">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl76" style="border-left:none">DO Review</td> <td class="xl72" style="border-top:none">GIW</td> <td class="xl73" style="border-top:none">Exhibit 2</td> <td class="xl75">Same?</td> <td class="xl76" style="border-left:none">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl78">DO Review</td> <td class="xl77">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl84" style="border-top:none;border-left:none">DO Review</td> <td class="xl77" style="border-left:none">GIW</td> <td class="xl77">Exhibit 2</td> <td class="xl75" style="border-left:none">Same?</td> <td class="xl84" style="border-top:none;border-left:none">DO Review</td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> <td class="xl79"> </td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-500</td> <td class="xl92">AK0007C0C001003</td> <td class="xl92">AK0007C0C001003</td> <td class="xl93">AK-500 - REN - Four A's SPC</td> <td class="xl94">AK-500 - REN - AK-500 - REN - Four A's SPC</td> <td class="xl95">No</td> <td class="xl96"> </td> <td class="xl93" style="border-left:none">SRA</td> <td class="xl92">SRA</td> <td class="xl95" style="border-left:none">Yes</td> <td class="xl97" style="border-left:none"> </td> <td class="xl93" style="border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-left:none">Yes</td> <td class="xl97" style="border-left:none"> </td> <td class="xl95">92-0047291</td> <td class="xl98" style="border-left:none">92-0047291</td> <td class="xl95">Yes</td> <td class="xl97" style="border-left:none"> </td> <td class="xl93" style="border-left:none" align="right">0</td> <td class="xl92" align="right">0</td> <td class="xl95" style="border-left:none">Yes</td> <td class="xl99"> </td> <td class="xl93" align="right">1</td> <td class="xl92" align="right">1</td> <td class="xl95" style="border-left:none">Yes</td> <td class="xl99"> </td> <td class="xl93" align="right">7</td> <td class="xl92" align="right">7</td> <td class="xl95" style="border-left:none">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">2</td> <td class="xl95" style="border-left:none" align="right">2</td> <td class="xl99">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">1</td> <td class="xl95" style="border-left:none" align="right">1</td> <td class="xl99">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">0</td> <td class="xl95" style="border-left:none" align="right">0</td> <td class="xl99">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">0</td> <td class="xl95" style="border-left:none" align="right">0</td> <td class="xl99">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">0</td> <td class="xl95" style="border-left:none" align="right">0</td> <td class="xl99">Yes</td> <td class="xl93"> </td> <td class="xl92" align="right">13</td> <td class="xl95" style="border-left:none" align="right">11</td> <td class="xl97" style="border-left:none"> </td> <td class="xl93" style="border-left:none"> </td> <td class="xl92" align="right">120864</td> <td class="xl95" style="border-left:none" align="right">120864</td> <td class="xl97" style="border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-500</td> <td>Anchorage CoC</td> <td align="right">2146312</td> <td align="right">661540</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-500</td> <td class="xl92" style="border-top:none">AK0003C0C001003</td> <td class="xl92" style="border-top:none">AK0003C0C001003</td> <td class="xl93" style="border-top:none">AK-500 - REN - ACMH SPC</td> <td class="xl94" style="border-top:none">AK-500 - REN - AK-500 - REN - ACMH SPC</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">24</td> <td class="xl92" style="border-top:none" align="right">24</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">2</td> <td class="xl95" style="border-top:none;border-left:none" align="right">2</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">2</td> <td class="xl95" style="border-top:none;border-left:none" align="right">2</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">28</td> <td class="xl95" style="border-top:none;border-left:none" align="right">28</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">298560</td> <td class="xl95" style="border-top:none;border-left:none" align="right">298560</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-500</td> <td>Anchorage CoC</td> <td align="right">2146312</td> <td align="right">661540</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-500</td> <td class="xl92" style="border-top:none">AK06C600001</td> <td class="xl92" style="border-top:none">AK06C600001</td> <td class="xl93" style="border-top:none">AK-500-New-RurAL CAP PSH</td> <td class="xl94" style="border-top:none">AK-500 - REN - AK-500 - REN - RurAl CAP SPC</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">5</td> <td class="xl92" style="border-top:none" align="right">5</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">5</td> <td class="xl95" style="border-top:none;border-left:none" align="right">5</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">89100</td> <td class="xl95" style="border-top:none;border-left:none" align="right">49560</td> <td class="xl97" style="border-top:none;border-left:none">No</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-500</td> <td>Anchorage CoC</td> <td align="right">2146312</td> <td align="right">661540</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-500</td> <td class="xl92" style="border-top:none">AK0029C0C001001</td> <td class="xl92" style="border-top:none">AK0029C0C001001</td> <td class="xl93" style="border-top:none">AK-500 - REN - Coming Home II</td> <td class="xl94" style="border-top:none">AK-500 - REN - AK-500 - REN - Coming Home II</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">13</td> <td class="xl92" style="border-top:none" align="right">13</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">4</td> <td class="xl95" style="border-top:none;border-left:none" align="right">4</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">2</td> <td class="xl95" style="border-top:none;border-left:none" align="right">2</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">19</td> <td class="xl95" style="border-top:none;border-left:none" align="right">19</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">214392</td> <td class="xl95" style="border-top:none;border-left:none" align="right">214392</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-500</td> <td>Anchorage CoC</td> <td align="right">2146312</td> <td align="right">661540</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-501</td> <td class="xl92" style="border-top:none">AK0016C0C011003</td> <td class="xl92" style="border-top:none">AK0016C0C011003</td> <td class="xl93" style="border-top:none">AK-501 - REN - Camai SPC</td> <td class="xl94" style="border-top:none">AK-501 - REN - AK-501 REN - Camai SPC</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">3</td> <td class="xl92" style="border-top:none" align="right">3</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">1</td> <td class="xl92" style="border-top:none" align="right">1</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">4</td> <td class="xl95" style="border-top:none;border-left:none" align="right">4</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">8</td> <td class="xl95" style="border-top:none;border-left:none" align="right">8</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">104496</td> <td class="xl95" style="border-top:none;border-left:none" align="right">104496</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-501</td> <td>Alaska Balance of State CoC</td> <td align="right">357813</td> <td align="right">376211</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-501</td> <td class="xl92" style="border-top:none">AK0030C0C011001</td> <td class="xl92" style="border-top:none">AK0030C0C011001</td> <td class="xl93" style="border-top:none">AK-501 - REN - Housing Now II</td> <td class="xl94" style="border-top:none">AK-501 - REN - AK-501 - REN Housing Now II</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">7</td> <td class="xl92" style="border-top:none" align="right">7</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">2</td> <td class="xl95" style="border-top:none;border-left:none" align="right">2</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">9</td> <td class="xl95" style="border-top:none;border-left:none" align="right">9</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">98472</td> <td class="xl95" style="border-top:none;border-left:none" align="right">98472</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-501</td> <td>Alaska Balance of State CoC</td> <td align="right">357813</td> <td align="right">376211</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-501</td> <td class="xl92" style="border-top:none">AK0024C0C011002</td> <td class="xl92" style="border-top:none">AK0024C0C011002</td> <td class="xl93" style="border-top:none">AK-501 - REN - Housing Now-1 SPC</td> <td class="xl94" style="border-top:none">AK-501 - REN - AK-501 - REN Housing Now-1 SPC</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">6</td> <td class="xl92" style="border-top:none" align="right">6</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">6</td> <td class="xl95" style="border-top:none;border-left:none" align="right">6</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">55584</td> <td class="xl95" style="border-top:none;border-left:none" align="right">55584</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-501</td> <td>Alaska Balance of State CoC</td> <td align="right">357813</td> <td align="right">376211</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AK-501</td> <td class="xl92" style="border-top:none">AK0018C0C011003</td> <td class="xl92" style="border-top:none">AK0018C0C011003</td> <td class="xl93" style="border-top:none">AK-501 - REN - Juneau SPC</td> <td class="xl94" style="border-top:none">AK-501 - REN - AK-501 - REN - Juneau SPC</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Alaska Housing Finance Corporation</td> <td class="xl92" style="border-top:none">Alaska Housing Finance Corporation</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">92-0047291</td> <td class="xl98" style="border-top:none;border-left:none">92-0047291</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">7</td> <td class="xl92" style="border-top:none" align="right">7</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">1</td> <td class="xl95" style="border-top:none;border-left:none" align="right">1</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">8</td> <td class="xl95" style="border-top:none;border-left:none" align="right">8</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">98208</td> <td class="xl95" style="border-top:none;border-left:none" align="right">98208</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Anchorage</td> <td>AK-501</td> <td>Alaska Balance of State CoC</td> <td align="right">357813</td> <td align="right">376211</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AL-500</td> <td class="xl92" style="border-top:none">AL0013C4C001003</td> <td class="xl92" style="border-top:none">AL0013C4C001003</td> <td class="xl93" style="border-top:none">AL-500 - REN - S+C AL0013C4C000802</td> <td class="xl94" style="border-top:none">AL-500 - REN - AL-500 - REN - S+C AL0013C4C000802</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">TRA</td> <td class="xl92" style="border-top:none">TRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Jefferson County Housing Authority</td> <td class="xl92" style="border-top:none">Jefferson County Housing Authority</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">63-6002200</td> <td class="xl98" style="border-top:none;border-left:none">63-6002200</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">97</td> <td class="xl92" style="border-top:none" align="right">97</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">167</td> <td class="xl95" style="border-top:none;border-left:none" align="right">167</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">128</td> <td class="xl95" style="border-top:none;border-left:none" align="right">128</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">17</td> <td class="xl95" style="border-top:none;border-left:none" align="right">17</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">1</td> <td class="xl95" style="border-top:none;border-left:none" align="right">1</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">410</td> <td class="xl95" style="border-top:none;border-left:none" align="right">410</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">4150836</td> <td class="xl95" style="border-top:none;border-left:none" align="right">4150836</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Birmingham</td> <td>AL-500</td> <td>Birmingham/Jefferson, St. Clair, Shelby Counties CoC</td> <td align="right">4087891</td> <td align="right">3371069</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AL-501</td> <td class="xl92" style="border-top:none">AL0040C4C011003</td> <td class="xl92" style="border-top:none">AL0040C4C011003</td> <td class="xl93" style="border-top:none">AL-501 - REN - Shelter Plus Care</td> <td class="xl94" style="border-top:none">AL-501 - REN - Shelter Plus Care</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">State of Alabama</td> <td class="xl92" style="border-top:none">State of Alabama</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">63-6000619</td> <td class="xl98" style="border-top:none;border-left:none">63-6000619</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">17</td> <td class="xl92" style="border-top:none" align="right">17</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">14</td> <td class="xl95" style="border-top:none;border-left:none" align="right">14</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">31</td> <td class="xl95" style="border-top:none;border-left:none" align="right">31</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none"> </td> <td class="xl95" style="border-top:none;border-left:none" align="right">243708</td> <td class="xl97" style="border-top:none;border-left:none">No</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Birmingham</td> <td>AL-501</td> <td>Mobile City & County/Baldwin County CoC</td> <td align="right">3099511</td> <td align="right">1866135</td> <td>HHN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AL-503</td> <td class="xl92" style="border-top:none">AL0046C4C031003</td> <td class="xl92" style="border-top:none">AL0046C4C031003</td> <td class="xl93" style="border-top:none">AL-503 - REN - Mental Health Center of Madison County Shelter Plus Care</td> <td class="xl94" style="border-top:none">AL-503 - REN - Mental Health Center of Madison County Shelter Plus Care</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">SRA</td> <td class="xl92" style="border-top:none">SRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Huntsville Housing Authority</td> <td class="xl92" style="border-top:none">Huntsville Housing Authority</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">63-6000392</td> <td class="xl98" style="border-top:none;border-left:none">63-6000392</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">23</td> <td class="xl92" style="border-top:none" align="right">23</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">19</td> <td class="xl95" style="border-top:none;border-left:none" align="right">19</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">42</td> <td class="xl95" style="border-top:none;border-left:none" align="right">42</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">307008</td> <td class="xl95" style="border-top:none;border-left:none" align="right">307008</td> <td class="xl97" style="border-top:none;border-left:none">Yes</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Birmingham</td> <td>AL-503</td> <td>Huntsville/North Alabama CoC</td> <td align="right">268995</td> <td align="right">451690</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">AL-503</td> <td class="xl92" style="border-top:none">AL09C503002</td> <td class="xl92" style="border-top:none">AL09C503002</td> <td class="xl93" style="border-top:none">AL -503-REN-Huntsville Housing Authority S+C Rental Assistance Project</td> <td class="xl94" style="border-top:none">AL-503 - REN - HHA Tenant Based Shelter Plus Care Program</td> <td class="xl95" style="border-top:none">No</td> <td class="xl96" style="border-top:none"> </td> <td class="xl93" style="border-top:none;border-left:none">TRA</td> <td class="xl92" style="border-top:none">TRA</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none">Huntsville Housing Authority</td> <td class="xl92" style="border-top:none">Huntsville Housing Authority</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl95" style="border-top:none">63-6000392</td> <td class="xl98" style="border-top:none;border-left:none">63-6000392</td> <td class="xl95" style="border-top:none">Yes</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">0</td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl99" style="border-top:none"> </td> <td class="xl93" style="border-top:none" align="right">8</td> <td class="xl92" style="border-top:none" align="right">8</td> <td class="xl95" style="border-top:none;border-left:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">0</td> <td class="xl95" style="border-top:none;border-left:none" align="right">0</td> <td class="xl99" style="border-top:none">Yes</td> <td class="xl93" style="border-top:none"> </td> <td class="xl92" style="border-top:none" align="right">8</td> <td class="xl95" style="border-top:none;border-left:none" align="right">8</td> <td class="xl97" style="border-top:none;border-left:none"> </td> <td class="xl93" style="border-top:none;border-left:none"> </td> <td class="xl92" style="border-top:none" align="right">227520</td> <td class="xl95" style="border-top:none;border-left:none" align="right">54048</td> <td class="xl97" style="border-top:none;border-left:none">No</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>Birmingham</td> <td>AL-503</td> <td>Huntsville/North Alabama CoC</td> <td align="right">268995</td> <td align="right">451690</td> <td>PPRN</td> <td>
</td> <td>
</td> </tr> </tbody></table>Here the macro that I am using, but it only works for one of the worksheets and it creates a bunch of new worksheets based on the unique cell data in column A starting with the 12th row (the prior rows are headers).
Code:
Sub PagesByDescription()
Dim rRange As Range, rCell As Range
Dim wSheet As Worksheet
Dim wSheetStart As Worksheet
Dim strText As String
Set wSheetStart = ActiveSheet
wSheetStart.AutoFilterMode = False
'Set a range variable to the correct item column
Set rRange = Range("A11", Range("A65536").End(xlUp))
'Delete any sheet called "UniqueList"
'Turn off run time errors & delete alert
On Error Resume Next
Application.DisplayAlerts = False
Worksheets("UniqueList").Delete
'Add a sheet called "UniqueList"
Worksheets.Add().Name = "UniqueList"
'Filter the Set range so only a unique list is created
With Worksheets("UniqueList")
rRange.AdvancedFilter xlFilterCopy, , _
Worksheets("UniqueList").Range("A11"), True
'Set a range variable to the unique list, less the heading.
Set rRange = .Range("A12", .Range("A65536").End(xlUp))
End With
On Error Resume Next
With wSheetStart
For Each rCell In rRange
strText = rCell
.Range("A11").AutoFilter 1, strText
Worksheets(strText).Delete
'Add a sheet named as content of rCell
Worksheets.Add().Name = strText
'Copy the visible filtered range _
(default of Copy Method) and leave hidden rows
.UsedRange.Copy Destination:=ActiveSheet.Range("A1")
ActiveSheet.Cells.Columns.AutoFit
Next rCell
End With
With wSheetStart
.AutoFilterMode = False
.Activate
End With
On Error GoTo 0
Application.DisplayAlerts = True
End SubIs it possible to have it do the same for both of the worksheets? Meaning, create a new spreadsheet with its name as each unique cell in column A with 2 worksheets (each with data based on the same unique column A values (e.g. AK-500. AK-501, etc)
Am I making any sense? I know it must sound confusing. I got thrown this task with 48 hours to do it in and if the macro does not work, I'll have to do everything manually (a la cut/paste
). I would greatly appreciate any insight into this.
ray:Dmitriy.
