binding rows of data

[vakhal]

hi, i wanted to know if you can bind rows of data that will stay in thier row if that row was moved. eg.

row A2 [cat] B2 [123] C2 [peppy]
row A3 [cat] B3 [538] C3 [dingo]
row A4 [dog] B4 [399] C4 [snoopy]

what i want to do is bind the rows so if i want to sort the data in ( column B ) numerical order, then everything in the row will move with it.
so numerically cell B4 would move up to cell B3, but cells A4, C4 would become A3, C3

if that makes any sence

[shg]

Just select all the columns you want to sort ...

[vakhal]

i'll try to explain it better

this is my data

A2 [cat] B2 [123] C2 [peppy]
A3 [cat] B3 [538] C3 [dingo]
A4 [dog] B4 [399] C4 [snoopy]

now if i sort say...column C in alphabetical order , with binding the rows together the result should be.


A2 [cat] B2 [538] C2 [dingo]
A3 [cat] B3 [123] C3 [peppy]
A4 [dog] B4 [399] C4 [snoopy]

so [peppy] moved from cell C2 to C3, but....[cat] and [123] also moved from their cells down to follow .

[shg]

I can only repeat: select the columns you want to sort together. Here, select B2:C4, and sort by column C.