I have sheet one with column A where names will be entered. Once names are entered, column B with populate the initials. These two columns are dynamic ranges. Sheet two, column A will have a drop-down where the selections would be the names, BUT when selected the initials that correspond to it would populate the cell instead.
Help.
Also, if names are deleted, modified, or moved, the drop-down list wouldn’t show blanks. All formulae are NOT to be in cells, but as dynamic ranges or otherwise.
I will PAY to learn, if need be. Ha ha
Is it possible?
HELP!!!!