Did you get an answer? I have similar need, I want to sort data automatically
and then move those sorted lines to another work book or local to another
excell sheet. How would I do it?

"RAL/PSCN" wrote:

I'm working with a database of names with additional information that's
growing quite large.

Is there a method/macro to automatically sort existing records and new ones
as they are entered into a series of "sub" worksheets divided into
alpha-groups (for example: A-E for sheet 1, F-J for sheet 2, K-O for sheet
3...etc.)

Thanks

RAL