Alphabatize list

  • Thread starter Thread starter belvy123
  • Start date Start date
B

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
 
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
 
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
 
Back
Top