The Workbook has 2 sheets. On Sheet 1, Column A is a list of Warehouse
locations, (1A1A is in Cell A3, 1A1B is in Cell A4, 1A1C is in Cell A5 and so
on). On Sheet 2 I am setting up Lable Location Templates which span Cells
A1:K35, with A1 containing the text of Sheet1!A3 (i.e. 1A1A)
I want Sheet2!A36 to display the data from Sheet1!A4 (i.e. 1A1B) and for
each copy down the page to do likewise. I was hoping there was some kind of
NEXT type formula for finding a value in a list and then returning the next
value from said list. The only other alternative I can see is hlookup but I
might as well type in all the values as I would have to change the row value
in the formula each time for this to function correctly. Any help is
appreciated