I want to sort one column in ascending mode and all rows get shifte
too, depending how this column get sorted.

View in excel sheet e.g.

A B C A B C
1 2 A CC 1 1 C BB
2 3 B AA = Sort column A= 2 2 A CC
3 1 C BB 3 3 B AA
: : : : : : :
:

Can anyone help me how to write VBA-code to sort one column
and the rows changes in the same way?

Does anyone now how to pick out one row and copy it to another sheet?

Best regards
Lar

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements