I am in Excel v2016 on Win11...
I am preparing a book catalog for my simple purpose of data entry, that is entry of bibliographic metadata (the usual title, author, etc.).
I have 9 column fields named with an alphanumeric 'code', a simple combination of a number (1-9) and 2 lowercase letters (a-z) .
I had the need to place these various codes in a dropdown for easy and consistent selection and, then, to add to that the actual data of each record.
As a simple example, I have the second column/field ( 2by ) in a dropdown
with listed the various roles of an author (author, editor, translator, etc.) in the data validation of the column.
2by, 2ed, 2tr, 2cm, etc. for the author, the editor, the translator, the commentator, etc .
Now my need is to add the actual data to the cell, after having selected the role from the dropdown list, i.e. the actual name of the author|editor|translator|commentator,
like this: 2byHemingway-Ernest
However, the cell is not allowing me to enter any further text to it, being blocked by the Data Validation not allowing me to write anything else in the space after the selected dropdown item
I found out, though, that if, in the Data Tab > DataValidation > ErrorAlert, I un-click the selectable box ShowErrorAlert, then I can enter in the cell all kind of extra text, without the DataValidation protesting to have entered any extra, 'un-permitted' text. In this way, with such a a simple solution my problem has been solved
My question, now, for you expert guys in this Forum is:
will this made-up 'solution' be tolerated by the Excel system, in the sense that is it possible that, down the line, serious problems shall be created to the sheet/workbook due to this ?
I am preparing a book catalog for my simple purpose of data entry, that is entry of bibliographic metadata (the usual title, author, etc.).
I have 9 column fields named with an alphanumeric 'code', a simple combination of a number (1-9) and 2 lowercase letters (a-z) .
I had the need to place these various codes in a dropdown for easy and consistent selection and, then, to add to that the actual data of each record.
As a simple example, I have the second column/field ( 2by ) in a dropdown
with listed the various roles of an author (author, editor, translator, etc.) in the data validation of the column.
2by, 2ed, 2tr, 2cm, etc. for the author, the editor, the translator, the commentator, etc .
Now my need is to add the actual data to the cell, after having selected the role from the dropdown list, i.e. the actual name of the author|editor|translator|commentator,
like this: 2byHemingway-Ernest
However, the cell is not allowing me to enter any further text to it, being blocked by the Data Validation not allowing me to write anything else in the space after the selected dropdown item
I found out, though, that if, in the Data Tab > DataValidation > ErrorAlert, I un-click the selectable box ShowErrorAlert, then I can enter in the cell all kind of extra text, without the DataValidation protesting to have entered any extra, 'un-permitted' text. In this way, with such a a simple solution my problem has been solved
My question, now, for you expert guys in this Forum is:
will this made-up 'solution' be tolerated by the Excel system, in the sense that is it possible that, down the line, serious problems shall be created to the sheet/workbook due to this ?
