Forum Discussion
Create a Formula to pull Data from 1 row, 3 columns on Sheet2 into multiple Rows and columns Sheet1?
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.
