Please help with a split of 1 spreadsheet into many based on the unique data.

viperx100

New Member
Joined
Mar 18, 2011
Messages
16
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:

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 Sub

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 :banghead:).

I would greatly appreciate any insight into this. :pray:

Dmitriy.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
The attached code will move thru Sheet("Org") and create additional Sheets named with the values in Column "A"

It can be expanded to cover many original Sheets

Code:
Option Explicit
Dim arrLastRow() As Long
Sub PagesByDescription()
    Dim rRange As Range, rCell As Range
    Dim wSheet As Worksheet
    Dim wsOrg As Worksheet
    Dim strText As String
    Dim RowNo As Long
    Dim Idx As Integer
    
    Set wsOrg = ThisWorkbook.Worksheets("Org")
    'Set a range variable to the correct item column
    Set rRange = wsOrg.UsedRange
    
    ReDim arrLastRow(0)
    'Delete all but the Orignal Spreedsheet
    Application.DisplayAlerts = False
    For Idx = ThisWorkbook.Worksheets.Count To 1 Step -1
        Select Case ThisWorkbook.Worksheets(Idx).Name
            Case "Org"
            
            Case Else
                ThisWorkbook.Worksheets(Idx).Delete
        End Select
    Next Idx
    Application.DisplayAlerts = True
    
    For RowNo = 13 To rRange.Rows.Count
        Debug.Print rRange.Cells(RowNo, 1)
        
        Idx = FindSheetIndex(rRange, rRange.Cells(RowNo, 1))
        rRange.Rows(RowNo).Copy _
            Destination:=Worksheets(Idx).Range("A" & arrLastRow(Idx))
        arrLastRow(Idx) = arrLastRow(Idx) + 1
    Next RowNo
End Sub
Function FindSheetIndex(OrgRange As Range, ByVal SheetName As String) As Integer
    Dim I As Integer
    Dim RowNo As Integer
    
    If SheetName = "" Then
        FindSheetIndex = 0
        Exit Function
    End If
    
    For I = 1 To ThisWorkbook.Worksheets.Count
        If ThisWorkbook.Worksheets(I).Name = SheetName Then
            FindSheetIndex = I
            Exit Function
        End If
    Next I
    
    ThisWorkbook.Worksheets.Add After:=Worksheets(Worksheets.Count)
    Sheets(Worksheets.Count).Name = SheetName
    ReDim Preserve arrLastRow(Worksheets.Count)
    arrLastRow(Worksheets.Count) = 12
    FindSheetIndex = I
    
    For RowNo = 1 To 12
        OrgRange.Rows(RowNo).Copy _
            Destination:=Worksheets(I).Range("A" & RowNo)
    Next RowNo
End Function
 
Upvote 0

Forum statistics

Threads
1,222,310
Messages
6,165,254
Members
451,948
Latest member
Lschuman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top