Help with VBA combobox references

[AequitasVeritas87]

I am familiar with the basic functions of excel but do not have extensive experience with VBA--I have been trying to learn but I cannot seem to find an answer to a specific task which I am trying to complete. I am working with a data table (shown above) of Units with a set number of designated stats (stat1, stat2, etc)--I want to be able to automatically populate the combobox at the top with the Unit names of this data table--and ideally, have this be a dynamic named range to which I can add more data on the fly.

Based on the unit selection from the combobox above, I want the stats of the selected unit to be populated in the cells marked above with the bold border. From a long list of units and their respective stats, I would like to be able to choose one from the combobox (which automatically populates new units) and have the relevant data populate in a designated range of cells.

Any help would be greatly appreciated!

 

[My Aswer Is This]

I looked at your question earlier and was hoping someone else would understand what you want. But sense that has not happened I must say from your image I can not see the relationship from what is show above and below in the image. Like where did these numbers 1 to 8 come from ?

And by: Your quote

I am working with a data table​

Does this mean a Excel Table?
And if so give me the name of the Table