Userform to store "option button value" in specific column

Hello

1.From Cell A2 to A1000, The userform7 will show once the cell is clicked.

2.Once the userform7 is displayed, the user can select an account, once the account is selected, the data will write into the cell e.g (A2)

3. After the user selects the account, userform8 will appear so that the user can then select an address.

What i want to do is, once the selection of the address is made on userform8, to be able to populate the selection into column D2

A different address is set for different accounts, so i am looking to store the address given the account on column D2 all the way down

Thanks

Sorry

The correct attachment is Book12

Thanks