I have a schedule program that uses one cell, (A1) lets say, and then corresponding to that persons name in A1 there is schedule data in B1:W2.

When I add a new employee or delete one, I need to re sort the list to accommodate the change and keep all scheduling information in sync.

My key column will be A, but data is only in every other cell. A1, A3, A5....A(n)

If I use a regular sort, all of the blank cells A2, A4, A6... will be sorted out and I will have two employee names in the space only one should be. (A1 and A2 instead of just A1 and a blank in A2)

Left column is what it is, right column is what I would get with a regular sort and it needs to be a name then a space, the next name and then a space.....


Alex Alex
Ben
Ben Charles
Dave
Charles Edward
Frank
Dave

Edward

Frank

some help with a sort routine that would work would be awesome.

thanks