Macro

Copper Contributor

Bonjour, je suis en train de monter un tableau pour mon horaire de travail, j'aimerais ajouter une macro qui ferait déplacer mes prochaines inspections en début selon la date du jour, la date de la prochaine inspection est dans la colonne F mais je ne me rappelle plus comment faire pour que le tableau se place selon la date du jour, SOS j'ai besoin d'aide le plus rapidement possible, merci de me répondre.

 

P.S. Les lignes complètes doivent se déplacer.

1 Reply

@France_2000 

 

Not knowing how your sheets are arranged, it's hard to offer exactly right advice. Excel has a relatively new function called SORT that could be used (without a macro) accomplish what you're seeking to do. Here's a YouTube video in English that explains it.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, but were limited to power users. With Dynamic Arrays we have rebuilt the calc engine, effectively turning all formulas into array formulas ...