I always pre-sort the data before Im going to create the usernames. This is more like a one time thing. I do not need to keep the file after the usernames are created.

Basically, what ill be doing is pulling a list of all users and usernames from our LDAP server and compiling them to and excel file. Afterward I will merge this list with new user data and by sorting the users that do not have usernames last copy the formula to those users. Once this process is done i basically copy the usernames, create passwords for them in a seperate program, and finally insert them through a mass import to their respective LDAP ou's.

Ultimately I would like to stay away from a macro because no one in my office except for me knows how to run macro's nor do i have the time to teach them. In case of my absence I need someone to be able to do this one the fly perferable with a formula; but if there is no other way i can settle for anything at this point.

Thanks again for all your help! Im really lost on this one.