Sort by column inside a worksheet

[flyingrhino]

This seems like a very trivial issue, but I have been googleing for it for the past hour !

I have a few colums (date, numbers, text) and all I want to do is add a little button at the top of the screen above each of the columns that sorts the entire list by whatever column I select to sort (ascending or descending).

This is driving me nuts as I cannot succeed in finding how to do it !

Please help,
Ken.

[Pete_UK]

Hi,

Have a look at this link:

http://www.contextures.com/xlSort02.html

Seems to be what you want.

Pete

[flyingrhino]

Thanks, this solution works for me.