Automatic association with value

Originally Posted by clemlcfc

... And would it be possible to have it appear automatically without clicking on any button or launching macro (Adding a name in 'Names' and then the rest appears automatically in 'Assocation') ??

Hello.
Of course it can be done automatically.

But what if you make a mistake typing a name and retype it "correctly", then you will have created data for the wrong name and data for the correct name?

That's why I think that -if you want it to be automatic- every time you enter (or delete) a name or a criterion I think it would be best to rewrite the entire resulting table.

Do you agree?...

thank you for your answer. Maybe i did something wrong but it does not seem to work for me !

Yes i understand your point. But in that case, would it not be possible that if i delete a value it would delete automatically. I agree it would be easier that everytime i enter (or delete) a name or a criterion it would be best to rewrite the entire resulting table

Thank you so much Sintek !

@sintek if i had a column in the second table it does not work anymore. Where do i change in the code to select the column manually ?

yes "add" my bad. my english isn't that good

Thank you for your answer ! 2 questions on that : if i modify the first table and add a column, it will modify the second table for each value that i enter. So how do i modify it to make it only do the program for the first column of the first page ?

Secondly, how can i also the second table and insert the value in specific columns (let's say 1 and 3 for example) and not the first two like in your example ? And also if a row has value elsewhere than column 1 and 3 (if we keep the logic), to tell the programm the stay in that row and not skip onto the next one directly ?

thank you for your time and help as always !

here is updated file : error-1.xlsm

my first problem is column B on first sheet, if i write it will do the programm when i want it to work only for first column.
second thing is on the second sheet, to modify to put value ok name and criteria in A and C, in the programm it works for first 2 columns.
And finally if there is value already in other column than 'name' and 'criteria' don't skip the line.

thank you so much

Sorry if i was not clear ! yes this is what i mean !

You are right it is not optimal. I will think about something else ! thank you