Hi,

I need a macro to populate values based in the column A, I have value in column A as below in column B the role should reflect


Column A Column B
Data1-Admin-2-1 Admin
Data1-Clerk-2-2 Clerk
Data1-Super-User-2-3 Super-User
Data2-Admin-2-1 Admin
Data2-Clerk-2-2 Clerk
Data2-Super-User-2-3 Super-User