Using Worksheets

C

CS

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
 
B

Biff

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
 
C

CS

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

CS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top