One way that I normally do is:

1) Define a Parameters Tab where all parameters are stored.
2) In this Parameters Tab, in one of the cells enter a formula using
Countif over a suitably large range (say 3000 rows when you expect to
have about 1000 or slightly more rows), which tells you how many rows
of names are populated.
3) Using Insert-Name-Define, name this cell suitably say
No_of_name_rows.
4) go back to your tab and create a button.
5) Using Record Macro actually sort your name list while recording your
macro.
6) Modify the recorded macro (after stopping) to use the value of the
No_of_name_rows which you defined in step 3.
7) Associate the macro with the button you created in step 4.

Now you can enter a few names and click the button and get the data
sorted.

As far as getting first name and last name in columns A and B but using
a combination of First and last name, you can do that by using
Concatenate function in the corresponding cell in Column C on the same
row.

Please write to me in case of questions.

Uttam


--
u0107
------------------------------------------------------------------------
u0107's Profile: http://www.excelforum.com/member.php...o&userid=11329
View this thread: http://www.excelforum.com/showthread...hreadid=554258