Data Validation list with unique values (drop down menu)

[0123ren]

I have a column of numbers which contains numerous repeated entries and blank cells. The list is free to expand as people can continually add to the list. The list can only expand to a finite number of rows, say 150.

Is it possible to use a bit of VB code to extract only unique entries and non-blanks from this list and copy it to another area so that this "new_list" can be named and used as data validation for a drop down menu.

I would like it to be automated so the length of the new_list created is recognised by the data validation so that there are not numerous blanks at the bottom of the drop-down menu as may be the case if numerous duplicate entries and blanks are removed.

I would be extremely greatful for any assistance.

PS I have looked at many related threads and although many solutions closely approach the one I require there are no direct matches. I am not a seasoned professional when it comes to excel so if I have failed to explain my situation using the correct terminology then please feel free to ask for further explanation.

Thanks in advance for any assistance offered!!

 

[Aladin Akyurek]

Thank you, Aladin. I would have never known since the link wasn't there for me.

The coloring of the quoted links do not seem stay out, so they are hard to notice.

 

[BeachRock]

Ah, there is a link there.... You're right. Very hard to notice. I didn't realize it was there.