Sort data 2nd rows

heeeeeeeeeeelp

Hi
See sample workbook. Formulas are in every other cell in column B. Then you can sort by surname.
Hope this helps.
Good luck.
Tony

I would suggest joining the surnames and first names together and then sorting and "unjoin" them afterwards. Something like:

Please Login or Register  to view this content.

(based on your data being in column A, starting at row 1)

That's much more difficult. Especially as you are throwing in merged cells! You'll have to give me a minute to come up with a solution.

Ok, I've come up with this:

Please Login or Register  to view this content.

I've tested it against the sample you provided and it seems to work.

thank you , but is error when is end I dont understand why

What is the error and where does it occur? I've just double-checked/tested it again and it still gave me the correct result for your sample.

Are you testing it on the sample or the full data?

look for this - sort.vA02.xlsm

The macro I gave you works on the data in sort.vA02.xlsm on my machine. Try putting it in a new module and running it from there rather than the command button? What is the error you get? Is it an error in the code? Or is the end result not what you want?

I work with command button , its my weakness, I use button to action and there si errror

Marianus, try changing this line in the code

Please Login or Register  to view this content.

Thank you for all