Hello, I have a sheet with about 4000 companies listed in column 'A' going down. I want to be able to create a profile for each, without having to doing it individuially for all 4000.

The headings i have in the sheet for each column are: Company name (column A), Contact name (column C), Phone number (column D), Email address (column E). In column B, i have the word "profile" going all the way down. When you click on the word "profile" it brings up a userform, the userform will ask to enter Contact name, phone number, email address with a save button. when I click save, it should export the data from the userform to each cell for that row only.

I can easily link the userform to these cells for one row, i dont know how to make it work for using one userform to populate different rows. I tried to explain as i best as i could, kindly assist if possible thank you.