In column B ther are Numbers from 2nd row to Last row. starting from 0001
in between in column B thereare numbers starting with "Z-" and these also respectively starting from 0001 but if i select in combobox "ABC"
I would like to auto increment the number with String "Z-0002 in the textbox when...