VBa count colum with names and display number on different sheet

[Isaac21]

Hello, I need some help creating a code that will count the number of times the words Junior, Senior, Master, Grand Master and Great grand master appears in row column "J" on a worksheet called "Combined" and then display that number on a different worksheet called "summary" in the cell next to the corresponding word the cells have named ranges for example c,15 is called Juniors... and so on for the rest

Images attached below to add some context, can provide more images if needed

If anyone can help with this i would appreciate as i don't know much about VBA,

Thanks
Isaac

 

[Fluff]

Any particular reason you need a macro, as this can be done with a simple formula.
In C15 dragged down

=COUNTIFS(Combined!J:J,B15)

 

[Isaac21]

Any particular reason you need a macro, as this can be done with a simple formula.
In C15 dragged down

=COUNTIFS(Combined!J:J,B15)

needs to be vba for assessment, thanks for reply

 

[Fluff]

If it's for an assessment, you should say so in your post.
What have you tried?