I would like to do the following:
I have a list of values in a column of a table (Column Name: CODES). I must manually
enter the correct correspondent code in a second comumn (Column Name: KEN).
After that I would like whenever I add a value in CODES (manually or as an import from another list), to have Excel or Access to automatically fill in the correct correspondent value in KEN column if there is one previously added.
Any answer is welcome.