I've got two worksheets in a workbook. In one of them I am creating a
seating chart for an auditorium. I have five rows of seats with the rows
running horizontally in the worksheet. In the other sheet I am trying to
link to the first sheet and put those students into a processional order for
a graduation ceremony. Linking to individual cells is no problem. The time
consuming part is that I am trying to turn the horizontal rows of seats into
vertical rows of the lines. To complicate things even more, one of the lines
needs to be reversed order...in other words the seat at the far right (AO12
for example) needs to be at the front of the line followed by AN12, etc while
the other line needs to go more in order with A12 first followed by B12, etc.
Is the easiest/only way to do this with a VB program to assign the cell
contents or can it be done with a formula?

To extract columnwise "in reverse", eg: AO12, then AN12, AM12, ...
Put in the starting cell, eg in A15, copy down:
=OFFSET($AO$12,,1-ROWS($1:1))

And to extract columnwise "normal" eg: A12, then B12, C12, ...
try in say, B15, copy down: =OFFSET($A$12,,ROWS($1:1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"woalmoore" wrote:
I've got two worksheets in a workbook. In one of them I am creating a
seating chart for an auditorium. I have five rows of seats with the rows
running horizontally in the worksheet. In the other sheet I am trying to
link to the first sheet and put those students into a processional order for
a graduation ceremony. Linking to individual cells is no problem. The time
consuming part is that I am trying to turn the horizontal rows of seats into
vertical rows of the lines. To complicate things even more, one of the lines
needs to be reversed order...in other words the seat at the far right (AO12
for example) needs to be at the front of the line followed by AN12, etc while
the other line needs to go more in order with A12 first followed by B12, etc.
Is the easiest/only way to do this with a VB program to assign the cell
contents or can it be done with a formula?