ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sort by column inside a worksheet (https://www.excelbanter.com/excel-worksheet-functions/82432-sort-column-inside-worksheet.html)

flyingrhino

Sort by column inside a worksheet
 

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.


--
flyingrhino
------------------------------------------------------------------------
flyingrhino's Profile: http://www.excelforum.com/member.php...o&userid=33322
View this thread: http://www.excelforum.com/showthread...hreadid=531459


Pete_UK

Sort by column inside a worksheet
 
Hi,

Have a look at this link:

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

Seems to be what you want.

Pete


flyingrhino

Sort by column inside a worksheet
 

Thanks, this solution works for me.


--
flyingrhino
------------------------------------------------------------------------
flyingrhino's Profile: http://www.excelforum.com/member.php...o&userid=33322
View this thread: http://www.excelforum.com/showthread...hreadid=531459



All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com