Using Worksheets

  • Thread starter Thread starter CS
  • Start date Start date
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
 
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
 
Back
Top