Adding Owner Name Based on Account Code in Column A

This is a copy of part of my long Financial Repor list in which I have to manually type in the name of the owners on top of each account in column B. It looks like below samples

I want a macro that automatically insert the owner names on top of each account number on column B based on account code in column A. It looks like this: If 40 on Column A, insert Taylor on the top of Column B, if 50, insert Brandon; if 60 insert Duval and so on….Then I will continue finish your macro until reaching the end of my record.

Thank you for your help! Tango

A B C
Taylor
40 12.14 7/1/2013
40 5.16 7/5/2013
40 8.43 7/12/2013
25.73


Brandon
50 6.12 7/1/2013
50 8.19 7/5/2013
50 125 7/12/2013
139.31


Duval
60 5.78 7/1/2013
60 6.45 7/5/2013
60 5.12 7/12/2013
17.35

Carlos
80 11.11 7/1/2013
80 31.16 7/5/2013
80 48.12 7/12/2013
80 134 7/18/2013
80 45.32 7/20/2013
269.71

Please attach a sample workbook with enough data to make it clear what is needed.

If 40 on Column A, insert Taylor on the top of Column B, if 50, insert Brandon; if 60 insert Duval and so on….Then I will continue finish your macro until reaching the end of my record

At the same time enter the Number and Name in a separate sheet so that we can match and add the names.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).