SOLVED

Tri automatique et numérotation

Copper Contributor

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.

 

Capture d’écran 2024-06-17 161213.jpg

3 Replies
best response confirmed by Alexandre97441 (Copper Contributor)
Solution

Hi @Alexandre97441 

 

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:

 

Sample.png

 

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

1 best response

Accepted Solutions
best response confirmed by Alexandre97441 (Copper Contributor)
Solution

Hi @Alexandre97441 

 

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:

 

Sample.png

 

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]

 

View solution in original post