Hi,
I have on going data in AH column.The data will be go on adding in this column.What I want is that I want to get dropdown in list the unique data and if any new data is not there ,then it will allow me to add manually and in subsequent row it will again update that new data too.
Suppose in AH column, from AH2:AH6 there is 3 unique data.I have created a data validation list in AH7.It is currently showing 3 unique data including blank spaces.Now in AH7,I want to add "Janet" this should be allowed to do entry and it must update the list in AH8 cell.
Is this possible ?If so,kindly help me in this.
Bookmarks