removing from lookup list records that are selected

[LFKim2018]

by using data validation we can lookup from a list and select a record.
my query is how can we delete that chosen record from the list as soon as it is selected?
it's like a cut and copy paste process but only it is in a drop down list via data validation.
hope this is clear.
many thanks

 

[AhoyNC]

Maybe this link will help.

https://www.extendoffice.com/documents/excel/2327-excel-hide-previously-used-items-in-dropdown.html

 

[LFKim2018]

Maybe this link will help.

https://www.extendoffice.com/documents/excel/2327-excel-hide-previously-used-items-in-dropdown.html

Thank you very very much..

is there a VBA for this?
many thanks