I am very new to vba and some help creating a code. I need to cut each unique Name record and paste it into it's own new sheet. I tried to find an existing code but had no luck. Can someone help me with this?
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Name | Title | Location |
Mike | admin | NC |
Mike | admin | NC |
Mike | Mgmt | NC |
Steve | admin | SC |
Steve | admin | SC |
Scott | Mgmt | MD |
Scott | admin | MD |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>