Excel - Organigramme : SmartArt créé automatiquement

Do you want to create an Organization Chart in one click? Thanks to this tutorial, you will be able to automatically fill out a SmartArt (org chart) from your employees' data (first name, last name and job title). This tutorial is divided into 4 steps: - Data preparation (attribution of hierarchical levels) - Consolidation of information in a cell - Addition of a summary table - Use of the macro (Excel VBA) Please find the macro in the comments section. You can then use it in your Excel file (08:13) PS: at the end of the tutorial, don't forget to save your file in .xlsm format

• #education
• #excel
• #graphique
• #macro
• #vba
• #organigramme