SOLVED

Tableau décalage

%3CLINGO-SUB%20id%3D%22lingo-sub-2274697%22%20slang%3D%22fr-FR%22%3ETable%20lag%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2274697%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20table%2C%20in%20an%20X%20file%2C%20(column%20A%20up%20to%20BV%20line%203%20to%20142).%20In%20column%20A%2C%20B%2C%20C%2C%20D%2C%20there%20is%20data%20that%20is%20pasted%20linked%20from%20another%20excel%20file%2C%20file%20Y%2C%20or%20I%20count%20something%20else.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20have%20a%20new%20employee%20I%20add%20it%20to%20the%20Y%20file%20and%20it%20gets%20copied%20into%20the%20X%20file%3C%2FP%3E%3CP%3EIn%20the%20F%2CG%2CH%2CI...%20I%20manually%20register%20for%20each%20worker%20how%20many%20times%20they%20have%20done%20it%20each.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Photo%20tableau.PNG%22%20style%3D%22width%3A%20543px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273111iDED28173797E1B5B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Photo%20tableau.PNG%22%20alt%3D%22Picture%20chart.%20PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20when%20I%20alphabetically%20reset%20the%20Y%20file%20the%20data%20I%20manually%20enter%20into%20the%20X%20file%20(column%20F%2C%20G%2CH%2CI)%20does%20not%20follow%20the%20name.%20Its%20shift%2C%20so%20the%20data%20that%20were%20in%20the%20lines%20below%20is%20found%20a%20line%20higher.%20Martin%26amp%3Bapos%3Bs%20data%20shifts%20to%20Addition%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Photo%20tableau%20avec%20ajout.PNG%22%20style%3D%22width%3A%20536px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273110i7DC7BC2F0ED9727A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Photo%20tableau%20avec%20ajout.PNG%22%20alt%3D%22Photo%20tableau%20with%20addition.%20PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%26amp%3Bapos%3Bll%20have%20another%20solution%2C%20I%20may%20not%20have%20the%20right%20chart%3A%20I%20have%20to%20make%20a%20chart%20to%20count%20the%20number%20of%20different%20tasks%20per%20employee%20per%20month.%20So%20I%20have%203%20variables%3A%2012%20months%2C%20140%20employees%2C%2030%20tasks%20and%20more%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20plan%20to%20make%20a%20tab%20for%20each%20month...%20if%20you%20better%20would%20have%20perfect%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2274697%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Bonjour, 

J'ai un tableau excel, dans un fichier X, (colonne A jusqu'à BV ligne 3 à 142). Dans la colonne A, B, C, D, il y a des données qui sont collés lié a partir d'un autre fichier excel, fichier Y, ou je comptabilise autre chose. 

Lorsque j'ai un nouvel employé je l'ajoute au fichier Y et il se copie dans le fichier X

Dans les colonnes de tâche F,G,H,I... J'inscrit manuellement pour chaque travailleur combien de fois ils l'ont fait chaque. 

Photo tableau.PNG

Mon problème est que quand je remet en ordre alphabétique le fichier Y les données que j'entre manuellement dans le fichier X (colonne F, G,H,I ) ne suivre pas le nom. Sa décale, donc les donnée qui étaient dans les lignes en dessous se retrouve une ligne plus haut. Les données de Martin décale à Ajout

Photo tableau avec ajout.PNG

 

Peut-être aurez vous d'autre solution, je n'ai peut-être pas le bon tableau : Je dois faire un tableau pour comptabiliser le nombre de tâche différente par employé par mois. J'ai donc 3 variable : 12 mois, 140 employés, 30 tâches et plus

 

Présentement je prévois faire un onglet pour chaque mois... si vous avez mieux se serait parfait 

 

Merci pour votre aide

6 Replies

@annesophieplourde Can't be certain from just looking at the pictures, but you have hidden column E. If that one is empty, sorting columns A to D will not be synchronised with columns F to H.

@Riny_van_Eekelen 

annesophieplourde_1-1618508610802.png

Il y a des données

@annesophieplourde Then I don't know. Can you upload your file?

best response confirmed by annesophieplourde (New Contributor)
Solution

@annesophieplourde 

If these are simple links they actually mean that you take values from Y files in accordance to their row-column coordinates. If you reorder these data it affects A:D in file X, values appear here in another order but actually you don't sort records in X. Since data in columns from F are not connected to A:D data they stay in their own place independently on which values are returned by links.

 

Actually you need manually enter data in some column into both files, that could be person ID. Based on it you may lookup (XLOOKUP, whatever) other data which are now in A:D. Independently of sorting Y it always returns the same data based on ID. Data from F also will be connected to ID since they are in the same record and ID is entered manually. With that you may sort/filter X and Y independently.

Thank you ! Merci ça a fonctionner

@annesophieplourde , you are welcome