Hello
Is it possible to have a cell populate an alpha numeric sequence based on the selection from a data validation list?
For example I was hoping to be able achieve - if someone selects “Design” from the drop down, this would cause the next cell to populate “DR134” and so on sequentially each time the “Design” option is selected.
If someone selected “Project” this would trigger “PR089” and so on instead.
Any assistance would be greatly appreciated!
Is it possible to have a cell populate an alpha numeric sequence based on the selection from a data validation list?
For example I was hoping to be able achieve - if someone selects “Design” from the drop down, this would cause the next cell to populate “DR134” and so on sequentially each time the “Design” option is selected.
If someone selected “Project” this would trigger “PR089” and so on instead.
Any assistance would be greatly appreciated!