Sorting data then exporting to new sheet

[dkinnz]

I've been trying to figure this out for a while now, but I've realized that I need some help.
I'm looking to create a macro (command button) that will rearrange 5 columns (A, B, C, D, E) of data by sorting the numeric values of Column C in a descending order.

Lets say I have...
A B C D E
5 2 13 8 8
1 3 4 4 9
5 8 9 1 2
2 3 2 9 10
etc.

I want a macro to make it look like this...
A B C D E
5 2 13 8 8
5 8 9 1 2
1 3 4 4 9
2 3 2 9 10

In my application, there will be about 50 rows of data. I then want the macro to (after the data is sorted) export the first 10 rows of data to a new excel sheet.
For now, I'll be extremely grateful if someone can fill me in on how to just sort the data, but if you can also give me a hint on how to export a range of data that would be great.

Thanks!

[raypayette]

Select the columns A to E
Click Data, Sort, Sort by Column C, Descending

[dkinnz]

I'm trying to do this in VBA and maybe use the AutoSort command?
Any thoughts/examples on using Autosort?
I've figured out how to export data into a new sheet though.

Thanks,
dkinnz

[VBA Noob]

Hi,

This crude code give you any idea's

Please Login or Register  to view this content.

VBA Noob

[dkinnz]

That helped a ton. muchos thanks!

[VBA Noob]

Glad it helped

VBA Noob