I downloaded the packing slip template from the excel template samples site
and have incorporated it into my current workbook. Is there anyway to have
the name and address cells reference the information already contained in
cells on other sheets? I already have everything typed into my orders
spreadsheet, and would rather not have to copy/paste zillions of times to
print the packing slips. I have already figured out how to make the item
numbers and quatity ordered cross reference between the two sheets, but I
can't get the address and name text to do the same. any help would greatly be
appreciated.