Forum Discussion
Solved
Tri automatique et numérotation
Bonjour,
Je souhaiterais automatiser le tri de ma feuille Excel selon la couleur des cellules de la colonne D. (Toutes les cellules de couleur jaune, puis toutes les cellules de couleur verte,...).
Dans le même temps, j'aimerais que le numéro de bon d'évacuation suive le réagencement.
Merci d'avance.
A.
No idea what version of Excel you run nor on which platform (see recommendations in Welcome to your Excel discussion space!). Searched this site < 5 minutes and found Sorting Column by colors coded. Applied the approach with 365/Windows, works like a charm:
Re. Dans le même temps, j'aimerais que le numéro de bon d'évacuation suive le réagencement
As you can see on the left side of the picture you should select - first - all columns that must follow the sorting or better Format data as Table, in which case all columns will auto. follow when you sort [Transporteur]
3 Replies
No idea what version of Excel you run nor on which platform (see recommendations in Welcome to your Excel discussion space!). Searched this site < 5 minutes and found Sorting Column by colors coded. Applied the approach with 365/Windows, works like a charm:
Re. Dans le même temps, j'aimerais que le numéro de bon d'évacuation suive le réagencement
As you can see on the left side of the picture you should select - first - all columns that must follow the sorting or better Format data as Table, in which case all columns will auto. follow when you sort [Transporteur]
Lorenzo ,
Thank you for your help. It works perfectly, even without the part about "Format data as table". If I see a problem, I'll try to add this point.
Again, thank you.
Alexandre97441 You're welcome & Thanks for providing feedback
Just to clarify, the point about Table is to make life easier 🙂 In your scenario you would have No column to select first
