I want to do some data validation in my excel workbook. I want to use as many centralized values as possible for the data validation as the same values are used for multiple sheets. Now I have added some validation for Currency codes (USD...). the validation is based on a list in another sheet and its working kinda good. my problem is that I can still enter lower case values and not just exact values. I would prefer a solution which does not use VBA is possible. If its only possible with VBA, then please add some information on how to add it to the workbook and such.
The values i want to allow are:
CHF EUR GBP USD DKK SEK NOK
and the data validation looks like this:
=Sheet1!$S$2:$S$8 but also allows the values above as lower case which is not what i want (i see that i can list the values inside the data validation and then it only accepts exact matches, but for the sake of not having much work if the values change, i want to have them centralized).
I think it would be also good enough to convert the values into upper case, but it has to happen in the same cell eg. I enter
eur in cell
J6 then it should convert the value to upper case and write it also in