I have created a database of names and associated information. Names are
located in A1 thru A500 and sorted alphabetically. Corresponding data is
contained in B thru I for each name. Now I would like to break up the list
so that A-K is on worksheet1, L-S on worksheet2 and the remaining T thru Z
on the worksheet3. What would be the best method of copying the information
and then be able to add or delete names and data, and have it propagated
into the correct sheet alphabetically?
Thank you in advance.

CS

Hi!

What is the format of the names column?

Last_name, First._name

There may be better ways to do this but I think this is fairly easy to do
with formulas. It's easy but somewhat "involved". Others may recommend pivot
tables but they're not automatically dynamic.

If you're interested let me know and I'll put together a sample file.
(tomorrow, it's getting late where I am).

Biff

"CS" wrote in message
...
I have created a database of names and associated information. Names are
located in A1 thru A500 and sorted alphabetically. Corresponding data is
contained in B thru I for each name. Now I would like to break up the list
so that A-K is on worksheet1, L-S on worksheet2 and the remaining T thru Z
on the worksheet3. What would be the best method of copying the
information
and then be able to add or delete names and data, and have it propagated
into the correct sheet alphabetically?
Thank you in advance.

CS

(A1)Last Name (B1) First Name (C1) Address etc etc ..(H1)
Any suggestions appreciated.

CS

"Biff" wrote in message
...
Hi!

What is the format of the names column?

Last_name, First._name

There may be better ways to do this but I think this is fairly easy to do
with formulas. It's easy but somewhat "involved". Others may recommend
pivot
tables but they're not automatically dynamic.

If you're interested let me know and I'll put together a sample file.
(tomorrow, it's getting late where I am).

Biff

"CS" wrote in message
...
I have created a database of names and associated information. Names are
located in A1 thru A500 and sorted alphabetically. Corresponding data
is
contained in B thru I for each name. Now I would like to break up the
list
so that A-K is on worksheet1, L-S on worksheet2 and the remaining T thru
Z
on the worksheet3. What would be the best method of copying the
information
and then be able to add or delete names and data, and have it propagated
into the correct sheet alphabetically?
Thank you in advance.

CS

Here's a sample file:

http://s48.yousendit.com/d.aspx?id=1...X2DMX2DZMSMWXB

Read the notes!

Biff

"CS" wrote in message
...
(A1)Last Name (B1) First Name (C1) Address etc etc ..(H1)
Any suggestions appreciated.

CS

"Biff" wrote in message
...
Hi!

What is the format of the names column?

Last_name, First._name

There may be better ways to do this but I think this is fairly easy to do
with formulas. It's easy but somewhat "involved". Others may recommend
pivot
tables but they're not automatically dynamic.

If you're interested let me know and I'll put together a sample file.
(tomorrow, it's getting late where I am).

Biff

"CS" wrote in message
...
I have created a database of names and associated information. Names are
located in A1 thru A500 and sorted alphabetically. Corresponding data
is
contained in B thru I for each name. Now I would like to break up the
list
so that A-K is on worksheet1, L-S on worksheet2 and the remaining T
thru
Z
on the worksheet3. What would be the best method of copying the
information
and then be able to add or delete names and data, and have it
propagated
into the correct sheet alphabetically?
Thank you in advance.

CS