Impression multiples sous condition

%3CLINGO-SUB%20id%3D%22lingo-sub-1840046%22%20slang%3D%22fr-FR%22%3EMultiple%20prints%20under%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1840046%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20I'm%20looking%20to%20create%2Fuse%20a%20function%20or%20macro%20allowing%20me%20to%20make%20multiple%20impressions%20under%20conditions.%20I%20would%20like%20to%20simplify%20the%20printing%20of%20invoices%20for%20my%20mother's%20child%20care%20accounts.%20The%20idea%2C%20is%20to%20allow%20him%20to%20make%20all%20the%20impressions%20of%20any%20invoice%20whose%20amount%20is%20more%20than%200%20euros%20simply%20by%20pressing%20a%20button.%3C%2FP%3E%3CP%3EI%20created%20two%20pages%20excel%3A%3C%2FP%3E%3CP%3E-%20The%20first%20is%20a%20database%20in%20which%20the%20name%20of%20each%20child%20enrolled%20in%20the%20daycare%20appears%2C%20as%20well%20as%20the%20total%20number%20of%20hours%20spent%20in%20daycare%20for%20all%20children%20in%20that%20family.%20Knowing%20that%20there%20are%204%20tariffs%3A%3C%2FP%3E%3CP%3E%240.76%20for%2030%20minutes%3C%2FP%3E%3CP%3E%241.37%20for%201%20hour%3C%2FP%3E%3CP%3E%242.13%20for%201%20hour%20and%2030%20hours%3C%2FP%3E%3CP%3E%243.05%20for%202%20hours%20or%20more.%3C%2FP%3E%3CP%3ESo%20my%20mother%20has%20to%20return%20all%20these%20values%20once%20a%20month.%3C%2FP%3E%3CP%3E(Each%20line%20corresponds%20to%20a%20different%20family%2C%20so%20there%20is%20a%20bill%20for%20each%20family)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E-%20The%20second%20is%20a%20spreadsheet%20containing%20the%20typical%20model%20of%20the%20invoice.%3C%2FP%3E%3CP%3EI%20simply%20created%20a%20%22data%20validation%22%20that%20allows%20all%20the%20information%20listed%20in%20the%20database%20to%20appear%20on%20the%20invoice.%20(Name%2C%20first%20name%2C%20address%20and%20the%20number%20of%20hours%20spent%20by%20the%20children%20of%20this%20family%20in%20daycare)%20%3CBR%20%2F%3E%20On%20this%20page%20is%20calculated%20the%20total%20amount%20in%20euros%20due%20to%20the%20daycare.%3C%2FP%3E%3CP%3EMy%20mother%20has%20to%20click%20on%20the%20cell%20containing%20the%20data%20validation.%20A%20drop-down%20menu%20appears%20with%20all%20the%20names%20of%20each%20family.%20She%20clicks%20on%20one%20of%20the%20names%20to%20make%20it%20look%20like%20the%20corresponding%20bill%20with%20the%20total%20amount%20owed%20to%20the%20daycare.%20Finally%2C%20she%20has%20to%20make%20an%20impression%20for%20this%20family.%20She%20must%20renew%20the%20operation%20for%20each%20last%20name.%20All%20this%20is%20faster%20than%20doing%20all%20this%20by%20hand%20but%20is%20still%20too%20tedious%20for%20my%20taste.%20Since%20the%20town%20hall%20does%20not%20have%20a%20very%20high%20budget%2C%20it%20cannot%20buy%20a%20license%20for%20software%20worthy%20of%20the%20name.%20I%20would%20like%20to%20allow%20this%20town%20hall%20to%20continue%20to%20save%20money%20while%20making%20my%20mother's%20work%20easier.%20(Because%20I%20love%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20%20it%20hihi%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1840046%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1841098%22%20slang%3D%22de-DE%22%3ESubject%3A%20Impression%20multiples%20sous%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841098%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F852357%22%20target%3D%22_blank%22%3E%40Geo37Info%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20You%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20not%20to%20be%20misunderstood%2C%20in%20the%20community%20it%20is%20the%20aim%20of%20excel%20users%20to%20give%20help%20on%20their%20project%20(from%20Excel%20users)%2C%20or%20rather%2C%20to%20provide%20food%20for%20thought%20and%20not%20to%20deliver%20finished%20work%20or%20finished%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour je cherche à créer/utiliser une fonction ou macro me permettant de faire des impressions multiples sous conditions. Je voudrais simplifier l'impression de factures pour les comptes de garderie de ma mère. L'idée, est de lui permettre de réaliser toutes les impressions de toute facture dont le montant est supérieur à 0 € simplement en appuyant sur une touche.

Je lui est créé deux pages excel :

- La première est une base de données dans laquelle le nom de chaque enfant inscrit à la garderie apparait, ainsi que le nombre total d'heures passé à la garderie pour l'ensemble des enfants de cette famille. Sachant qu'il existe 4 tarifs :

0.76€ pour 30 minutes

1.37€ pour 1 heure

2.13€ pour 1heure30

3.05€ pour 2heures et plus.

Ma mère doit donc rentrer toutes ces valeurs une fois par mois.

(Chaque ligne correspond à une famille différente, il y a donc une facture pour chaque famille)


- La seconde est une feuille de calcul contenant le modèle type de la facture.

J'ai simplement créé une "validation des données" qui permet de faire apparaitre sur la facture l'ensemble des informations listées dans la base de donnée. (Nom, prénom, adresse ainsi que le nombre d'heures passé par les enfants de cette famille à la garderie)
Sur cette page est calculé le montant total en euros dû à la garderie.

Ma mère doit cliquer sur la cellule contenant la validation des donnée. Un menu déroulant apparait avec l'ensemble des noms de chaque famille. Elle clique sur un des nom pour en faire appraitre la facture correspondante avec le montant total dû à la garderie. Enfin elle doit faire une impression pour cette famille. Elle doit renouveler l'opération pour chaque nom de famille. Tout ceci reste plus rapide que de faire tout ceci à la main mais reste encore trop fastidieux à mon goût. La mairie n'ayant pas un budget très élevé, elle ne peut pas acheter une licence pour un logiciel digne de ce nom. Je voudrais permettre à cette mairie de continuer de réaliser des économies tout en facilitant le travail de ma maman. (Parce que je l'aime hihi )

1 Reply

@Geo37Info 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

 

In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)