Hi Good Day All. My objective is to automatically generate a list of subject codes. The inputs are the Subject, Level and Number.
Example If I entered Maths,2,4 respectively, I would want an automatically generated output that says Maths2-1, Maths2-2,Maths2-3, Maths2-4. Please see worksheet attached for better clarification.
I am not sure if this can be solved with a formula or would vba be better. Any help will be greatly appreciated.
Bookmarks