Thanks alot for those ideas Jim and Andy. They sound very promising.

However, I need to give some more info about my project in order to
understand what to do exactly. I had originally posted a longer
question with more detail but i didn't get a good answer.

I've included it here and am wondering if your solutions will still
apply, with this additional info.

Thanks again, i think i'm heading in the right direction, Finally.

------

tying columns of data into a specified page size

--------------------------------------------------------------------------------

This may be an easy question.

I have 3 thin columns of data that are 1000 rows long.

I have kept them like this so that i can use the alphabetical-order
tool successfully.

However i need to, now, put this data into an 11/17 page. so there will
now be several greater columns of the 3-columned data side by side. I
want to format the page so that i can still use the alphabetical tool
in respects to the entire list (which is now spanning horizontally
across the sheet in many 3-column groups). As well, i need to maintain
that data in the 3 columns remains side-by-side. So, i need the
formatting to respect the 3 columns as "together" so that when i use
the alphabetical-order tool it "expands the selection" for all 3
columns (yet not the other columns which are now side by side)

Thank you.

By
-----------




--
byby