sort data

Originally Posted by shahcu

I need to create a macro that will sort the entire data based on the double click event. For example.. When B1 is double cliked the data should be sorted by Column B. The code will applicable on all columns. So if say i double click on C5 then the data should be sorted by Column C. Macro shud also contain the functionality of the sorting that lets say someone clicks on the same column again then it will invert the sort direction.

This code would work when double clicking,

Please Login or Register  to view this content.

AS for undoing the macro, I suppose an Undo macro would work
Check it out here
http://www.j-walk.com/SS/excel/tips/tip23.htm