+ Reply to Thread
Results 1 to 3 of 3

create name badges with same data front and back from Excel list

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Caledon, Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    create name badges with same data front and back from Excel list

    I am using mail merge to create name badges from data in Excel 2010. I am using an Avery template that has six badges to a sheet. The data is merged first row left right, then second row left right. etc. I would like to have the same data on front and back of each badge. So far I have done it by printing a one-sided sheet of badges, then creating a second worksheet with the data manually reordered so that row one and two are switched, row three and four are switched, etc. Then I merged this second sheet, flip the sheet that I printed and I end up with the data correctly positioned front and back. Here's my question: is there a way to automatically reorder my rows of data, so that the order of pairs of rows are flipped? Thanks for any help.

  2. #2
    Registered User
    Join Date
    12-11-2014
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    94

    Re: create name badges with same data front and back from Excel list

    Let's create a mockup, then you can adjust it from there. Let's create a "Front Spot" column and copy that down, thus:

    Name Front Spot
    A 1
    B 2
    C 3
    D 4
    E 5
    F 6
    G 7
    H 8
    I 9
    J 10
    K 11

    Now we need to create a third column "Back Spot." In that column, put this formula and drag it down:

    =IF(B2/2=INT(B2/2),B2-1,B2+1)

    This just basically switches 1&2, 3&4, etc. Then, you'll want to sort by "Front Spot", and do your merge for the front of the tags. Then, sort by "Back Spot" and do your merge for the backs.

  3. #3
    Registered User
    Join Date
    03-12-2013
    Location
    Caledon, Canada
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: create name badges with same data front and back from Excel list

    Thanks. Perfect!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 11-07-2013, 02:48 PM
  2. Implement back end DB whien using excel as front end DB
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2012, 06:39 PM
  3. Access Front-end, Excel Back-end
    By dreicer_Jarr in forum Excel General
    Replies: 3
    Last Post: 03-08-2010, 08:07 PM
  4. [SOLVED] I can not get excel to print on front and back can anyone help me.
    By de_stap in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-01-2006, 02:40 PM
  5. [SOLVED] RE: How can I print on the front and back of a page in excel?
    By Jonathan Cooper in forum Excel General
    Replies: 0
    Last Post: 09-29-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1