Exporter données filtrées dans nouvelle feuille

%3CLINGO-SUB%20id%3D%22lingo-sub-2895595%22%20slang%3D%22fr-FR%22%3EExport%20filtered%20data%20to%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2895595%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EMy%20question%20is%20very%20simple%20and%20I%20suspect%20that%20the%20answer%20involves%20the%20pivot%20tables%20that%20I%20have%20never%20used%2C%20but%20the%20cases%20are%20too%20numerous%20to%20find%20this%20simple%20answer%2C%20so%20here%20it%20is...%3C%2FP%3E%3CP%3EMy%20expenses%2Fincome%20are%20listed%20in%20a%20sheet%20organized%20as%20follows%3A%20Date%20-%20Budget%20item%20-%20(amount%20of)%20Expenditure%20-%20(amount%20of)%20Income%20-%20Bank%20balance.%20I%20want%20to%20automatically%20report%20each%20budget%20item%20in%20separate%20tabs%20(sheets)%20rather%20than%20having%20to%20constantly%20filter%20on%20the%20Budget%20Item%20column.%3C%2FP%3E%3CP%3EHow%20to%20do%20it%3F%20Thanks%20in%20advance!%3C%2FP%3E%3CP%3ERobGreg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2895595%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2898658%22%20slang%3D%22en-US%22%3ERe%3A%20Exporter%20donn%C3%A9es%20filtr%C3%A9es%20dans%20nouvelle%20feuille%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2898658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1198710%22%20target%3D%22_blank%22%3E%40RobGreg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20do%20separate%20sheets.%20see%20video%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fe-CFYi52gpc%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2Fe-CFYi52gpc%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

Ma question est très simple et je me doute que la réponse implique les tableaux croisés dynamiques que je n'ai jamais utilisés, mais les cas de figure sont trop nombreux pour arriver à trouver cette réponse simple, alors voici...

Mes dépenses/revenus sont listées dans une feuille organisée comme suit: Date - Poste budgétaire - (montant de) Dépense - (montant de) Revenu - Solde bancaire. Je veux reporter automatiquement chaque poste budgétaire dans des onglets (feuilles) distincts plutôt que d'avoir à constamment filtrer sur la colonne Poste budgétaire.

Comment faire? Merci d'avance!

RobGreg

1 Reply

@RobGreg 

 

Don't do separate sheets. see video:

https://youtu.be/e-CFYi52gpc