If there's regularity in the structure of the other stuff that you want
compiled from other sheets into Packing Slips, think there might be a way to
extend the earlier OFFSET(..,INT(..),MOD(..)) in col B to cover.

I'd need to examine an actual sample of what you have over there. Use either
of the 2 filehosts below to upload the sample. Then copy n paste the
generated link to your sample file in response he

http://www.flypicture.com/
http://cjoint.com/index.php

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amazon H." wrote:
Thanks Max. This is definitely 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.