Récupération de donnée

matse57

XLDnaute Nouveau
Bonjour,

J’ai un problème pour une automatisation de fichier, je dispose d’un fichier brut comme que j’ai mis en pièce jointe « TableauBrute » la première feuille du classeur. Ce fichier présente des clients un par un, cependant les données ne sont pas sur la même ligne. Donc il est difficile d’en faire un traitement statistique.
De ce fichier je souhaiterais réaliser le document « Tableau» qui se trouve dans le second classeur. Chaque client correspond à une ligne et chaque variable à une colonne.

Je pense qu’il est possible de le réaliser automatiquement en utilisant du VBA. En effet car chaque fois il y a le même écart entre 2 données de la même variable sauf quand il y a la présence d’enfant dans le fichier.

Enfaîte il faudrait que lorsque je me déplace d’une ligne dans le tableau « Tableau » , que je me déplace de 28 ligne dans le « TableauBrute » .

Comment serait-t-il possible de réaliser ceci ? En utilisant le glissement ? Ou VBA ?

Cependant certain client possède des enfants comme le client 3, c’est données sont inutile faudrait juste que je sache le nombre d’enfant.
Supprimer ces lignes automatiquement me semble infaisable, et manuellement ceci peut prendre beaucoup de temps.

-Une solution est de créer un espace de 5 lignes pour tous les clients, pour que l’écart reste le même. Cependant comment ?
Faire une macro que lorsque l’on trouve l’information par exemple « porteur de carte » qu’on sélectionne la ligne en dessous.

-Enfaîte je pense a une boucle qui passe toute les lignes d’une colonne si il trouve le texte « porteur de carte » qui sélectionne le colonne d’en dessous ou se trouve l’information est qu’il l’envoi dans le second classeur en mettant les information une en dessous de l’autres.

Je dispose d’un fichier CSV aussi, qui ne ressemble pas exactement au fichier Excel quand on l’ouvre, mais je peux dispose de tout le fichier d’un seul coût. Je sais pas si il possible directement à partir du fichier CSV de réaliser ce que je veut.


Je précise que je travaille sur Excel 2003. Mon fichier brut contient plus de 63000 lignes (Excel n’arrive pas à l’ouvrir d’un coût), mais je peut sélectionner le fichier en plusieurs fois donc sa iras.. Le fichier ranger devra contenir 35000 lignes environs.
Les données du fichier joint ne sont pas réelles.


Code:
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Client 2XXXXXXXXXX  SACHATU Alain (Mr)","(suite)","","Accepte les mailings",":","Oui","Téléphone",":","03 XX XX XX 51","47YYY LUTYNIOL","1a Rue DU PETIN","47YYY LUTYNIOL","Date de création",":","25/07/91","Type d'habitation",":","Maison","FRANCE","FRANCE","Date de mariage",":","","Résidence principale",":","Oui","Zone géographique","Zone géographique","4 CLTS PLUS DE 65MN","4 CLTS PLUS DE 65MN","Date du dernier achat",":","16/12/05","Age du client",":","45 ans","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","Mr SACHATU Alain","05/11/48","Retraités","","","Du","","au","","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","","","","","","Du","23/02/10","au","28/02/10","15.75","15.75","9","6","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/03/10","au","31/03/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/04/10","au","30/04/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/05/10","au","31/05/10","11.13","114.3","1","5","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/06/10","au","30/06/10","122.3","12.30","1","4","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/07/10","au","31/07/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/08/10","au","31/08/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/09/10","au","30/09/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/10/10","au","31/10/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/11/10","au","30/11/10","15.40","155.0","1","3","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/12/10","au","31/12/10","175.2","75.02","1","4","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/01/11","au","31/01/11","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/02/11","au","21/02/11","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","","","","","","Du","","au","","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Client 2XXXXXXXXXY  GIROL Pat (Mr)","(suite)","","Accepte les mailings",":","Oui","Téléphone",":","","47YYY LUTYNIOL","19 chemin de hutttttt","47YYY LUTYNIOL","Date de création",":","21/05/07","Type d'habitation",":","Maison","FRANCE","FRANCE","Date de mariage",":","","Résidence principale",":","Non","Zone géographique","Zone géographique","4 CLTS PLUS DE 15MN","4 CLTS PLUS DE 15MN","Date du dernier achat",":","02/10/16","Age du client",":","61 ans","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","Mr GIROL Pat","14/03/47","Ouvrier","","","Du","","au","","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","","","","GIROL paelle","26/01/80","Du","","au","","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","Porteur de carte","Né le","Catégorie socio-professionelle","Enfants","Né le","Période","Panier Moyen","CA","Nb visites","Nb articles","","","","","","Du","23/02/10","au","28/02/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/03/10","au","31/03/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/04/10","au","30/04/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/05/10","au","31/05/10","15.60","31.19","2","2","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/06/10","au","30/06/10","1.0","3.30","1","3","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/07/10","au","31/07/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/08/10","au","31/08/10","2.79","3.79","1","4","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/09/10","au","30/09/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/10/10","au","31/10/10","150.00","50.00","1","56","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/11/10","au","30/11/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/12/10","au","31/12/10","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/01/11","au","31/01/11","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""
"DETAIL CLIENTS D'UNE SELECTION","23/02/11","Sélection 9 Test","Page 1/1","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Critère de selection:","Résultats de la sélection:","6 clients sélectionnés","6 client sélectionné,","correspondant à 6 foyer","(dont 6 acceptant de recevoir un mailing)","","Sélection 9 Test","DETAIL CLIENTS D'UNE SELECTION","23/02/11","Récapitulatif des achats mensuels du 23/02/10 au 21/02/11, classement par nom de client","Page 1/1","","","","","","Du","01/02/11","au","21/02/11","","","","","rptWCLN011 - TRIDUTRE (pseudoU)",".../...","rptWCLN011 - TRIDUTRE (pseudoU)","Impression terminée le 23/02/11 à 10:23",""


Merci
 

Pièces jointes

  • Donnée.xls
    24.5 KB · Affichages: 60
  • Donnée.xls
    24.5 KB · Affichages: 55
  • Donnée.xls
    24.5 KB · Affichages: 61

Discussions similaires

Réponses
2
Affichages
485