Sélectionner parmis plusieurs feuilles excel dans une seule feuille

%3CLINGO-SUB%20id%3D%22lingo-sub-3126657%22%20slang%3D%22fr-FR%22%3ESelect%20from%20multiple%20excel%20sheets%20in%20a%20single%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3126657%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20file%20containing%20many%20Excel%20sheets%20that%20have%20the%20same%20structure%20but%20only%20the%20year%20of%20the%20exercise%20varies%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tobias_O_0-1644234313716.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345809iC0C2DD09030D7159%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tobias_O_0-1644234313716.png%22%20alt%3D%22Tobias_O_0-1644234313716.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20is%20to%20say%20that%20all%20my%20sheets%20have%20the%20same%20structure%20but%20I%20have%20one%20for%20the%202018%20Financial%20Year%2C%20one%20for%20the%202019%20Financial%20Year%2C%20ect...%20The%20data%20inside%20also%20varies%20depending%20on%20the%20Exercise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20group%20everything%20on%20a%20single%20excel%20sheet%20and%20be%20able%20to%20move%20from%20one%20exercise%20to%20another%20quickly%20so%20as%20not%20to%20clutter%20up%20with%20several%20dozen%20Excel%20sheets%2C%20is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanking%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3126657%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3126728%22%20slang%3D%22en-US%22%3ERe%3A%20S%C3%A9lectionner%20parmis%20plusieurs%20feuilles%20excel%20dans%20une%20seule%20feuille%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3126728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1299259%22%20target%3D%22_blank%22%3E%40Tobias_O%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20first%20need%20I%20guess%20can%20be%20achieved%20using%20the%20following%20solution%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fautomatic-entry-of-data-from-a-cell-on-one-worksheet-to%2Fm-p%2F1617576%23M73350%22%20target%3D%22_self%22%3ESolution%3C%2FA%3E%3C%2FP%3E%3CP%3EFor%20the%20second%2C%20I%20would%20recommend%20you%20using%20Hyperlink%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

 

J'ai un fichier contenant de nombreuses feuilles Excel qui ont la même structure mais seul l'année de l'exercice varie :

Tobias_O_0-1644234313716.png

C'est à dire que toutes mes feuilles ont la même structure mais j'en ai une pour l'Exercice 2018, une pour l'Exercice 2019, ect... Les données à l'intérieur varient également en fonction de l'Exercice.

 

Je souhaite tout regrouper sur une seule feuille excel et pouvoir passer d'un exercice à un autre rapidement pour ne pas m'encombrer avec plusieurs dizaines de feuilles Excel, cela est-il possible ?

 

En vous remerciant

 

 

1 Reply

@Tobias_O 

Your first need I guess can be achieved using the following solution:

Solution

For the second, I would recommend you using Hyperlink formula.