How to assign a number to course name in inputbox

[mukeshbaviskar]

Hi friends,
In column ‘o’ I have inserted a number for course name in column ‘p’. I want to assign a course name to that particular number as follows:

Column ‘o’ Number ... Column ‘p’ Course name
1: A. B. C.
2: J. K. L.
3: P. Q. R.
4: X. Y. Z.

And so on as per course names.

If I enter number 1 in inputbox then I want to enter the course name in column ‘b4’ respectively.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you.

Mukesh

[nathansav]

Whats happening? Are the 2 input boxes always "answered"

need more info

[mukeshbaviskar]

Hi nathansav,
Sorry for confusing information. In short while filtering the course name in column 'p' I have to type a long name of of that particular course which I want to avoide. So I think to assign a course name to a number. My requirement is if I type a number in inputbox then it should change to that particular course assign to that particular number.

The second input box is for academic year. The final goal of this code is to create a student's list of that particular year and course which is done.

So please don't think of that second inputbox. Hope this will clear your confusion.

Thanking you.

Mukesh