Joined: 15 Nov 2010
|Posted: Sun Jun 17, 2012 7:23 am Post subject: Can II make button for Data Pilot to sort data?
Apologies for asking the same question again - but I'm still struggling with this question.
I'm creating a basic template for creating a family budget.
I'm still a beginner at Calc.
I really would like to create a simple button, without using macros, which says 'SORT" and it automatically highlights all the data, then sorts just the columns I want. I've worked out how to do it with Data Pilot - but I need a more simple approach (ie less options on how to sort data).
Here is sample file: