Sorry, but that's not how the program is designed - each column is separate
& distinct from the others. Newspaper style [or "snaking"] columns are not
supported. Even if it could be rigged programmatically 2008 doesn't support
VBA, so that isn't even an option.
The only conceivable approach I can think of would be to create a typical
continuous list on one sheet then create formula references in the preferred
columns of another sheet. That might work as long as the number of records
doesn't vary. For example:
The primary list might occupy Sheet1 cells A1:A300, then on Sheet2 cells
A1:A100 would contain:
=Sheet1!A1
through
=Sheet1!A100
Cells B1:B100 of Sheet2 would contain:
=Sheet1!A101
Through
=Sheet1!A200
Cells C1:C100 of Sheet2 would contain:
=Sheet1!A201
Through
=Sheet1!A300
When you sort the data on Sheet1 the results on Sheet2 would update
accordingly but you can see the problem if you're going to be
adding/deleting records in the master list on Sheet1... Which I would guess
is going to be the case, otherwise there would be no reason to repetitively
sort a data range consisting of only a single column.
There may be additional suggestions from other responders so check back
several times. Perhaps if you could provide more descriptive info about the
nature of your data & your actual objectives/requirements there may be other
approaches that would be more feasible.
Regards |:>)
Bob Jones
[MVP] Office:Mac
