Macro to populate 2 x 2 name tag; front and back
Hello!
I am hoping to be able to use a macro to populate name tags in MS Word with first and last names on the front and roles and schedule on the back. The names and roles are listed in an excel spreadsheet.
There are two word docs, the one labelled 'Allen Bagwell AM' is the front of the name tag, the word doc labelled 'Allen Bagwell Back' is the back of the tag. The word docs both contain four name tags per sheet in a 2 x 2 grid format.
Here is the catch, the 'AM Bagwell back' DOC must be populated in a different order than the front.
The layout of the front is given below. The numerals 1-4 represent the first four names on the excel sheet (rows 4-7).
1 2
3 4
To ensure the back of the name tag is accurate and contains the role of the person listed on the front it should be populated in a different order the back would be populated as
2 1
4 3
This means that the first name on the Excel spreadsheet (row 4) goes in the top left of the word doc 'Allen Bagwell AM' (position 1) but that person's assignment goes in the top right of the Back 'Allen Bagwell AM BACK' (aka position 2). The excel file could probably be re-ordered to accomplish this and then plugged in to the macro as usual.
The assignments are listed in column 'C' and they go above the Schedule of Events in the 'Allen Bagwell AM BACK' doc. The schedule of events should remain unchanged.
I would like if the macro could populate just one sheet at a time as I must save each sheet with a certain label. The alternative to this would be to create one large MS Word doc with all 83 names as the front doc and a separate doc with all 83 assignments for the back.
My inclination is this could also be done via mail merge, but I am so new to that function that I thought I would ask here first.
Thank you in advance!
Melissa
|