If you select your range (all of it--not just that one column), then do your
data|sort, all the other columns will move when you sort.

And record a macro when you do it manually once. You'll see the code.


Xel wrote:

I want to sort one column in ascending mode and all rows get shifted
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
Lars

------------------------------------------------
~~ 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

--

Dave Peterson