its not working
textbox value not appear in proper place subjects (English, Hindi, Maths, Sociology etc. are in B2:B4 which reflect in B2:B46 and years (2019-20, 2020-21, 2021-22 etc. are in C1:F1 which reflect in combobox2 but when I choose subject hindi (which is in B3 subject and Year 2020-21 (Which in D1) when I put 2 in textbox1 its not reflect in proper place (proper place is D3)
Suppose I select B2 subject English form combobox1 and Year D1 - 2021-21 from combobox2, the value of textbox is 1 which should be comes in D2
A B C D E F
1 S.No Subject 2020-21 2021-22 2022-23 2023-24
2 1 Eng - 1 - -
3 2 Hindi - - - -
4 3 Math - - - -
textbox value not appear in proper place subjects (English, Hindi, Maths, Sociology etc. are in B2:B4 which reflect in B2:B46 and years (2019-20, 2020-21, 2021-22 etc. are in C1:F1 which reflect in combobox2 but when I choose subject hindi (which is in B3 subject and Year 2020-21 (Which in D1) when I put 2 in textbox1 its not reflect in proper place (proper place is D3)
Suppose I select B2 subject English form combobox1 and Year D1 - 2021-21 from combobox2, the value of textbox is 1 which should be comes in D2
A B C D E F
1 S.No Subject 2020-21 2021-22 2022-23 2023-24
2 1 Eng - 1 - -
3 2 Hindi - - - -
4 3 Math - - - -