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
--
crunchnin numbers

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

On Feb 11, 7:12*am, belvy123
wrote:
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
--
crunchnin numbers

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




--
cruchnin numbers


"Pete_UK" wrote:

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

On Feb 11, 7:12 am, belvy123
wrote:
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
--
crunchnin numbers

.

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

On Feb 11, 10:49*am, belvy123
wrote:
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

--
cruchnin numbers



"Pete_UK" wrote:
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

On Feb 11, 7:12 am, belvy123
wrote:
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
--
crunchnin numbers

.- Hide quoted text -

- Show quoted text -