Sorting data based on a column but move the entire row

[Jackcell]

Hi all,

I would like to sort my data based on a column. As of now, only the values in the particular column is being sorted. The other column values do not move along. I would like the entire row to move along too. Is there any way to do it via Excel Macro?

Cheers,
Jack

 

[footoo]

Example :

Range("A1:F10").Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlYes

 

[Jackcell]

Thanks for the reply! Your code works.