I'm looking for someone to help me with VBA code so I click a button and my sheet 1 becomes organized like the data in Sheet 2
I would want the data in Column A,B,C to be used and added to the end of column D.
Key Points, I would want
Groomsman converted to the letter "g"
Best Man converted...