Forum Discussion
Create a Formula to pull Data from 1 row, 3 columns on Sheet2 into multiple Rows and columns Sheet1?
I'm making badges for a club and each badge on Sheet1 is 5 columns by 7 rows, with one row and column in between each badge. When I try to make the formula autofill, It grabs every 8th or 9th name on...
You've had over 80 views and no replies. I suspect it's partly due to the difficulty giving a "simple" answer in Excel. So I'm going to be bold and make a suggestion, that being a simple answer that uses some of what you've done, but goes in a different direction,
If I were doing this, I'd use your Excel list (Sheet2) as the source file, but use Mail Merge in Microsoft Word for the output. You'd have much more control of the layout of the badges themselves in Word, and the matter you're concerned about--getting each name in sequence--would be handled very easily; that's how MailMerge works! Here are some YouTube videos that explain how to do exactly that, using Excel as the source, Word for output.
The second task you describe (printing on both sides) would be accomplished by just running the routine twice, having the badges down the center of the page so they line up on each side.
Mail merge might work, but to make them double sided, seems like a waste of paper since it'll have to use twice as much. And that's also assuming the printer wouldn't grab any pages out of order, which I've seen printers do plenty of times.. Thanks for the idea, but I think I'm still gonna try to make excel work..
