Besoin d'aide

%3CLINGO-SUB%20id%3D%22lingo-sub-2308521%22%20slang%3D%22fr-FR%22%3ENeed%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308521%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20try%20to%20automate%20a%20file%20to%20make%20quotes%20faster%20and%20easier.%3C%2FP%3E%3CP%3EHere%20is%20my%20first%20tab%20(1%20Customers%20tab)%20where%20I%20want%20to%20be%20able%20to%20enter%20all%20my%20customers'%20information%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-04-29%20a%CC%80%2022.27.08.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276932i9BCCCF0B3CE37736%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-04-29%20a%CC%80%2022.27.08.png%22%20alt%3D%22Screenshot%202021-04-29%20at%2022.27.08.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20here's%20the%20blocking%20part%20(tab%202%3A%20Quotes)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-04-29%20a%CC%80%2022.30.12.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276933i64961A2162780299%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-04-29%20a%CC%80%2022.30.12.png%22%20alt%3D%22Screenshot%202021-04-29%20at%2022.30.12.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20idea%20is%3A%3C%2FP%3E%3CP%3EI%20would%20like%20to%20enter%20the%20information%20of%20my%20(prospects)%20on%20tab%201%20by%20informing%20the%20different%20information%3A%20company%20name%2C%20contact%2C%20such%2C%20address%20etc%20ETC%20AND%20I%20would%20like%20that%20when%20I%20am%20on%20the%20Devis%20tab%20when%20I%20put%201%20or%202%20or%203%20or%204%20or%205%20in%20box%20A18%20%2C%20that%20depending%20on%20the%20number%20of%20the%20devis%20tab%2C%20it%20will%20automatically%20get%20me%20the%20information%20to%20complete%20the%20part%20concerning%20the%20company%20to%20which%20I%20make%20the%20quote%20automatically%20and%20that%20this%20info%20comes%20to%20itself%20automatically%20put%20the%20or%20I%20indicated%20company%20name%2C%20address%20etc.%20.%20Is%20that%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2308521%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315174%22%20slang%3D%22fr-FR%22%3ERe%3A%20Need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315174%22%20slang%3D%22fr-FR%22%3E%3CP%3EIs%20it%20that%20complicated%20or%20am%20I%20explaining%20myself%20badly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315186%22%20slang%3D%22en-US%22%3ERe%3A%20Besoin%20d'aide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041186%22%20target%3D%22_blank%22%3E%40Eza_Exnihilo%3C%2FA%3E%26nbsp%3BWhy%20not%20upload%20your%20file(s)%3F%20That%20is%2C%20the%20one(s)%20you%20took%20the%20pictures%20from.%20Very%20difficult%20to%20do%20something%20with%20pictures%20alone.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315358%22%20slang%3D%22fr-FR%22%3ERe%3A%20Need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315358%22%20slang%3D%22fr-FR%22%3Esorry%2C%20its%20a%20good%20idea!!%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

J'essaye d'automatiser un fichier pour réaliser des devis plus rapidement et facilement.

Voici mon premier onglet (onglet 1 Clients) ou je souhaite pouvoir entrer toutes les informations de mes clients:

Capture d’écran 2021-04-29 à 22.27.08.png

 

Et voici la partie qui bloque (onglet 2 : Devis):

Capture d’écran 2021-04-29 à 22.30.12.png

L'idée est la suivante:

J'aimerais entrer les informations de mes (prospects) sur l'onglet 1 en renseignant les différentes informations : nom entreprise , contact , tel, adresse etc etc  ET j'aimerai que lorsque je suis sur l'onglet Devis lorsque je met 1 ou 2 ou 3 ou 4 ou 5 dans la case A18 , qu'en fonction du numéro de l'onglet Devis, ca aille me chercher automatiquement les informations pour compléter la partie concernant l'entreprise à qui je fais le devis automatiquement et que ces infos viennent se mettre automatiquement la ou j'ai indiqué nom de l'entreprise, adresse etc . Est ce possible ? 

Merci de votre aide

3 Replies

C'est à ce point compliqué ou je m'explique mal ?

@Eza_Exnihilo Why not upload your file(s)? That is, the one(s) you took the pictures from. Very difficult to do something with pictures alone.

sorry, its a good idea !!