Forum Discussion
Extending sort on .xlsm
With your permission, if I may recommend you, please explain your plans in more detail.
Insert photos or the file (without sensitive data) and on the basis of these photos or file,
explain your problem step by step, so that a proposal for a solution can be submitted faster and more precisely.
Adding you, the Excel version and the operating system would be an advantage in providing help.
Here are some tips on this topic: Welcome to your Excel discussion space!
Thank you for your understanding and patience
- linedbmDec 16, 2021Copper Contributor
NikolinoDE
Hello, thank you for your answer ! I'll try my best to explain the situation more precisely. First of all, I'm a Microsoft 365 user.
I created a collaborative xlsm file accessible on Onedrivve. It compares different Edtech.
Columns are the different criteria as : name, prices, feedback, screenview, satisfaction ... and the lines are the different softwares (Kahoot, animaker.... around 50)
A macro exist to add 1 by double click if we are satisfy or not by the software or not.
The filter for the two first criteria (goal and name of the software) are fine. But, using the sorting a->z or z->a cause a mix in the data !
To fix this problem I think of 2 possibilities : 1) remove the sorting a->z and z->a or 2) extend the sorting process for the all line. I think 1) is impossible and 2) the pop up to extend the sorting do not appear so ... I don't know what to do now 😃
You will find picture of this file here.