Need help sorting code

[EXLent]

So I've search sorting and saw many type of sorting and many solved.
I don't know how to word it but here's a picture.
This is a list of phones and it's specs.
If I sort Column "C" for example, how can I make it stay within its Row?
If i sort any column manually, the rest of the cell/box just stay the same.
hope it make sense.
phone.jpg

[:) Sixthsense :)]

Just select the entire range and apply the sorting

[EXLent]

Ha?
example: If I click on MEMORY column, it would sort that column. Any cell left or right of it follows.

[:) Sixthsense :)]

Selecting the data and sorting will applicable to selected data only

[alvin-chung]

Base on your attached image, you can try following step-by-step:
1. Select cells A3:F17 (or till end of your data range)
2. Goto [Data] menu, click [Sort] icon and you'll see the Sort dialog box popped-up
3. Uncheck [My data has headers] if it's checked
4. In the [Sort by] column, click on the drop down and select [Column C] (modified the order if necessary, else leave it as default for ascending order)
5. Click OK



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[EXLent]

Thanks Alvin
Thanks but no Thanks to 6sense
I think I got it.

Please Login or Register  to view this content.

[alvin-chung]

You're welcome, glad it helps



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[EXLent]

I actually just got done watching youtube.
I was able to record macro and use it codes.
Otherwise yours would of been helpful too.
Still Kudos to you.

[alvin-chung]

Yea, that's one of the great source too.
Thanks for the repu and don't forget to marked this thread as [SOLVED] using Thread Tools



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin