Need help on vba code/excel formula to use!

[ynyend1]

Hello all
Greetings!
I have attached a workbook here containing sample data and clear explanation of what I need.
This is what I want to achieve:

I need an Excel formula/VBA Code that will do the following:
1: Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE which will change automatically as average marks changes for each subject as per the criteria given in column AO and AP.. Refer to the combined results column in the attached workbook for the output I want; then:
2: If the student does not take any of the above subjects then it should not concatenate that particular subject with its marks, it should leave it blank and proceed to the next subject; refer to the second student in the attached sheet (check the combined result for the second students, that's the output I want).

I will highly appreciate for your help!

SAMPLE FILE FOR FORMULA HELP.xlsx
	AA
3	39
Sheet1

Cell Formulas
Range	Formula
AA3	AA3	=IFERROR(AVERAGE(C3,O3),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:AK4	Expression	=$A3=""	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B3:B4	List	ME,KE
C3:AK4	Whole number	between 0 and 100

 

[ynyend1]

Not in This workbook. Go to Insert Module and paste code only one time.
And Delete all codes with same name at workbook.

Helloooo..
I have now realised where the problem is..
It's because my data are Formatted as Table.... If I convert them to Range it works perfectly...
Is there a way to make a code that is compatible with Table format! It's because my template has some linked data to Power Query from Excel Tables... If there is no way then I will know what to do...
Thank you for your tireless efforts