Splitting a cell with "/" delimeter and use first part as new line heading

[CastMaster]

Please consider helping me with this...:banghead:

Here is what I have on a sheet:


NAME (B)

Date/time info (C)
Agent (D)

Role/Notes (E)


Sam Smith
4-29-2015 5:15 PM
WM

Jimmy/Has Issues


Bud Light
4-29 2015 3:12 PM
CAA

Jimmy/No Travel


Dick Wood
4-23-2015 4:10 PM
Front

Xavier/Not interested


Al Kida
4-4-2015 2:00 PM
Manager

Paul/Wife pregnant




So here is what I need in VBA sheet module... Please note: Column E (Role/Notes) should split, then first part is moved to make new row heading in bold and in alphabetical order.
The second part of string remains in the cell. Additional data is frequently copied from another sheet into this as well so it would need to accommodate new data over time.


NAME (B)
Date/Time Info(C)
Agent(D)

Role/Notes(E)







Jimmy











Bud Light
4-29-2015 4:10 PM
CAA

No Travel







Sam Smith
4-29-2015 5:15 PM
WM

Has Issues







Paul











Al Kida
4-4-2015 2:00 PM
Manager

Wife Pregnant







Xavier











Dick Wood
4-23-15 4:10PM
Front

Not Interested































I am in the final leg of this 2 year journey to make this right (no kidding). Your help means everything to me. Is this do-able? Does it make sense?

[p45cal]

Check out the responses at your cross post at http://www.mrexcel.com/forum/excel-questions/852124-can-you-help-me-split-cell-use-first-part-new-row-heading.html