Order a column in a data table

[concatch]

Hi,

I have a data table that has a range E6:N736 (Incl Headings). The data table works well however I would like to order the last column ie column N in asc order. I've tried to select the data table and order however it doesn't allow me to do so. Ideally I would like a button that mimics F9 and then orders the data table as described about.

Any ideas?

Thanks

[patel45]

what do you mean for " however it doesn't allow me to do so" ?

[concatch]

Well you cant edit a data table so if you try order using the ribbon then it will return an error message

[patel45]

attach your file for testing

[concatch]

Did a work around. Created a rank column and then used a vlookup on the top 10 results.