Alphabatize list

[belvy123]

I have a list of em,ployees I want to alphabatize,. It has 2 pages with 2
columns of names on each sheet. I want the first part of the list on page 1
to have the name in the first half of the alphabet and the 2nd sheet to have
the second half. currently the first column has A-K and K is on the bottom of
the 2nd page and the 2nd column on page 1 startrs with K and goes through S
and carries through to the 2nd page and finishes with Z on the 2nd column of
page 2. So in short I would like A-K on page 1 in the 2 columns on page 1 and
L-Z on page 2 in the 2 columns on page 2

Thanks for the help

 

[Pete_UK]

It's a bit confusing when you talk about pages - are these printed
pages, or worksheets? How many names do you have? Are the two columns
used for forename and surname, or does column 1 contain (for example)
A-E then column 2 contains F to K ?

Please give further details.

Pete

 

[belvy123]

Sorry so confusing but ill try

All 1 sheet put has a pg break due to amount of names

Currently Sheet 1 pg 1

a j
b k
c l
d m

pg 2

e n
f o
g p
h q
i r

etc

I want it to be

Sheet1 Pg 1

a e
b f
c g
d h


pg 2

i n
j o
k p
l q
m r

etc
hope this helps

Thanks

 

[Pete_UK]

Check out this page from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

It shows how you can arrange columns to print across like in
newspapers.

Hope this helps.

Pete