VBA Button to fill in data based off dropdown list value

I have 10 rows of data with one of the columns called "Type". This column has either "Primary" or "Secondary" entered in. I then have a column at the end called "Provider" that needs to be filled in based off the functions of my "Primary" button. The button essentially will fill in the "Provider" column for all the "Primary" rows with whatever the value is selected in the dropdown list next to the button. The dropdown list has different telecom providers that the user can select. Is this possible at all? I tried a vlookup but unfortunately it only filled in the first cell that was labeled as "Primary" and not all of them.Excel.JPG

This works great. However, I forgot to mention that the column "Provider" is also a dropdown for someone to select a provider. The button is meant to ease the process of the possibility of selecting the same provider for each row and just have the button do it for them. This is my fault and I should have mentioned this.