Sort/Filter Data alphabetically into separate worksheets A-Z

[RAL/PSCN]

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

 

[Miltonslr]

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]

Nope. Never got an answer. The best I could come up with was to use a
series of worksheets and "RENAME" their identifying tabs (at the bottom of
the Excel Screen) using alphabetical ranges -- A-E, F-I, etc.). Users still
have to manually select the appropriate worksheet to enter data. Once the
data was entered (using Excel's standard "FORM" command) the best I could do
was create a new custom button for the toolbar that would automatically do an
alpha sort and save the file).

Sorry I don't have a better answer (yet...)

RAL/PSCN