ExcelBanter - Excel automaticly advancing copied cell numbers

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!