I seem to have lost the dropdown list when using data validation.
Everything else on the validation seems to work. i.e. it is correctly
not allowing amounts that are not correct.
I have checked if the correct boxes are ticked on the Data Validation>Settings sheet> both (Ignore Blank and In-Cell Dropdown) and they are ticked.
Is there anything else I can try.
Appreciate any help.