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?
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Title[/TD]
[TD="width: 64"]Location[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]admin[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]admin[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]Mgmt[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]admin[/TD]
[TD]SC[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]admin[/TD]
[TD]SC[/TD]
[/TR]
[TR]
[TD]Scott[/TD]
[TD]Mgmt[/TD]
[TD]MD[/TD]
[/TR]
[TR]
[TD]Scott[/TD]
[TD]admin[/TD]
[TD]MD[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Title[/TD]
[TD="width: 64"]Location[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]admin[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]admin[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]Mgmt[/TD]
[TD]NC[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]admin[/TD]
[TD]SC[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]admin[/TD]
[TD]SC[/TD]
[/TR]
[TR]
[TD]Scott[/TD]
[TD]Mgmt[/TD]
[TD]MD[/TD]
[/TR]
[TR]
[TD]Scott[/TD]
[TD]admin[/TD]
[TD]MD[/TD]
[/TR]
</tbody>[/TABLE]