•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Moving filtered rows with the correct line
Our take
When working with filtered rows in spreadsheets, it's crucial to manage how sorted data behaves, especially when dealing with checkboxes. If your checkboxes are scrambling when you sort your data from A to Z, it likely indicates that the sorting function is not maintaining the correct association between the rows and their corresponding checkboxes. This often happens when the data is not structured properly for sorting. Let’s explore how to ensure that your checkboxes remain aligned with their respective rows during filtering and sorting.
I would like move the checked boxes when I filter and click sort A>Z, but when I currently do that under the test row, it scrambles everything.
What am I doing wrong?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience