Aide au report d'un inventaire

%3CLINGO-SUB%20id%3D%22lingo-sub-2643457%22%20slang%3D%22fr-FR%22%3EAssistance%20in%20carrying%20over%20an%20inventory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643457%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20I've%20been%20digging%20my%20head%20for%20a%20while.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20an%20inventory%20chart%20where%20I%20note%20all%20the%20products%20I%20buy%2C%20the%20date%2C%20the%20cost%20and%20the%20type%20of%20product.%20Only%20here%2C%20I%20also%20have%203%20pages%20that%20takes%20care%20of%20the%20inventory%20of%20each%20type%20of%20product.%26nbsp%3B%3CBR%20%2F%3EI%20would%20like%20to%20set%20up%2C%20if%20possible%2C%20a%20formula%20that%20detects%20the%20types%20of%20products%20(we%20will%20say%20X%2C%20Y%2C%20Z)%20and%20that%20will%20copy%20me%20the%20entire%20line%20concerning%20this%20product%20(so%20date%20%2B%20cost)%20in%20the%20page%20of%20the%20type%20concerned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20I%20have%204%20pages%2C%20in%20order%20%3D%20Provisioning%3B%20Product%20inventory%20X%3B%20Inventory%20Y%3B%20Inventory%20Z%3B%20Summary.%3C%2FP%3E%3CP%3EIf%20I%20enter%20my%20first%20page%20that%20I%20bought%20on%2027%2F01%20a%20product%20type%20Y%20for%2014%20%E2%82%AC%2C%20I%20would%20like%20it%20to%20note%20in%20my%203rd%20page%20(Product%20inventory%20Y)%20a%20line%20%22%2027%2F01%20%7C%2014%20%E2%82%AC%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20other%20details%20but%20I%20wanted%20to%20simplify%2C%20I%20do%20not%20know%20which%20function%20to%20inquire%2C%20I'm%20sure%20it's%20all%20stupid%20!!%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20taking%20the%20time%20to%20read%20me%20and%20think%20about%20it%2C%20you%20will%20be%20of%20great%20help%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20not%20hesitate%20to%20contact%20me%20by%20email%20if%20necessary%3A%20%3CA%20href%3D%22mailto%3Acoco.seconde44%40gmail.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ecoco.seconde44%40gmail.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECdt%3C%2FP%3E%3CP%3EKaoEU%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2643457%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646683%22%20slang%3D%22en-US%22%3ERe%3A%20Aide%20au%20report%20d'un%20inventaire%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1127387%22%20target%3D%22_blank%22%3E%40KaoEU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVeuillez%20fournir%20un%20exemple%20de%20fichier%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour, voilà un moment que je me creuse la tête.

 

J'ai actuellement un tableau d'inventaire ou je note tous les produits que j'achètes, la date, le coût et le type de produit. Seulement voilà, j'ai également 3 pages qui s'occupe de l'inventaire de chaque types de produit. 
J'aimerai mettre en place, si possible, une formule qui détecte les types de produits (on va dire X, Y, Z) et qui va me copier la ligne entière concernant ce produit (donc date + cout) dans la page du type concerné.

 

Exemple : J'ai 4 pages, dans l'ordre = Approvisionement ; Inventaire produit X ; Inventaire Y ; Inventaire Z ; Récapitulatif.

Si je rentre dans ma premiere page que j'ai achete le 27/01 un produit type Y pour 14€, j'aimerai que ca note dans ma 3e page (Inventaire produit Y) une ligne " 27/01 | 14 € ".

 

J'ai d'autres détails mais j'ai voulu simplifier, je ne sais pas vers quelle fonction me renseigner, je suis sûr que c'est tout bête !!

Merci d'avoir pris le temps de me lire et d'y réfléchir, vous me serez d'une grande aide.

 

Hésitez pas a me contacter par mail si nécéssaire : coco.seconde44@gmail.com

 

Cdt,

KaoEU

1 Reply

@KaoEU 

 

Veuillez fournir un exemple de fichier