Thanks Max. This is definately what I was hoping for. The first formula
(for A1) worked wonderfully, but when I'm putting in the 2nd, I'm running
into some trouble. The example I gave was simpler than what I'm doing. The
actual packing slip looks like this:
______________________
Team/Club name: (pulled from Worksheet 1)
Student Name: (Pulled from Tally worksheet)

Cinnamon Rolls
Tuxedo Brownies
Pumpkin Rolls

Apple Dumpings
Carmel Turtle Cheesecake
White Choc. Rasp. Cheesecake
Festive Favorites Cheesecake


PRIZE CODE: (pulled from Prize worksheet)
______________________
I need the spaces in between the rows and with info pulled from multiple
worksheets, I can't figure out how to formulate it with the =IF one you gave
me. I can change the cell starting positions so if you assume that the info
I need from each worksheet starts on A1, I'll understand. Thanks.

Amazon H.


"Max" wrote:

Assume source data is in a sheet: Tally, cols A to C, with data from row2 down

In another sheet: Packing Slips,

Put in A1;
=INDEX({"Names";"Cookies";"Cakes";""},MOD(ROWS($1: 1)-1,4)+1)

Put in B1:
=IF(OFFSET(Tally!$A$2,INT((ROWS($1:1)-1)/4),MOD(ROWS($1:1)-1,4))=0,"",OFFSET(Tally!$A$2,INT((ROWS($1:1)-1)/4),MOD(ROWS($1:1)-1,4)))
Select A1:B1, copy down as far as required. If there's 500 source names to
cover, copy down by 500 x 4 lines per name = 2,000 rows to B2000. Cols A and
B will return the required results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amazon H." wrote:
Forgive me, I don't know much Excel lingo. I'm changing the layout of
packing slips for a fundraiser company.

The Tally Sheet read:
Column A Column B Column C
Cookies Cakes
Row1: Joey 5 2
Row2: Billy 3 1

The packing slips read:
Row1: Name - Joey
Row2: Cookies 5
Row3: Cakes 2
Row4: _________________________
Row5: Name - Billy
Row6: Cookies 3
Row7: Cakes 1

The individual student's sales are on one worksheet, but when I'm pulling
them onto the packing slip, the cells are several rows apart, therefore the
cell number advances that many. Any way to do this besides entering it on
all 250-500 packing slips by hand? Thanks!