How do I set up repeating headings in alphabetical order

[BA]

I am learning Spanish and have to conjurgate the verbs. I want to list the
verb and meaning on the top line,(the headings) then under that type in the
verbs in Present. past and used to for" I, you, he/she, we, they".
As I have many verbs do work through, can this be arranged so that once I
have my lists, my PC can automatically place these "headings" in alphabetical
order please. example below:
Verbo: Dar: (to give)
Presents Pasado used to
yo doy dí daba
tu das diste ........
el ...... ........ ........
nos ...... ......... .......
ellos ...... ......... ........

then leave a few lines and do the same format with a different verb.

then when I am finished, can the PC re arrange it so the headings are in
alphabetical order..?

Many thanks,
Brian

 

[Cliff Carson]

Brian,
I think you gave more information than most NG readers would want to know
. There are two parts to this problem, 1) sorting the headings, and 2)
moving everything so all the lists end up in the sort order of their
headings. Which part of the problem are you asking about? I never found a
general purpose sort routine in VBA so I use a very simple 15 line bubble
sort routine that I wrote myself. Moving the lists around seems more like a
tedious task than a challenging one. I suggest that you define a data type
that can hold all the information in a list then create an array of that
type into which you put all the data, then sort, then rewrite.

CC