CastMaster
04-29-2015, 12:12 PM
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?
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?