Use a proxy to find the right person

I have a Macro, it basically allocates Person and Grade Level to Classes in a new worksheet. It then makes bold any instance where a person is not in HC data. That is not that important, it is all functioning well. In my code, I highlighted, in bold, the area I need help on. This is where I figure out if the data is missing and then make it bold. Instead of making it bold I was wondering if it was possible, to try to allocate the data based off the last 4 digits of the person, but with the first 3 being 011. In my sample workbook, I am missing HC data for 015 5858, I would then like to see if there is HC data for 011 5858 and then copy that data within the HC sheet (but replacing the Person as 015 5858). In my workbook I included a HC sheet and a HC After... the HC after is what I would like the end result to be.

There is always 3 spaces in between the left numbers and the right numbers and they are stored as text. I am basically looking for something that will, within that IF statement I bolded, Find "011 " & RIGHT(cname,4) in HC, and copy all instances below the last row but replaced cname for the person (in this example 015 5858).

Please Login or Register  to view this content.

Edit:
I have the following code done, I think I may just need help with my Copy/Paste coding

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Woooh