Copy Random Generated Number to new Sheet

[farhadj]

Good Day



I have Sheet2 that has random numbers in column A. A macro chooses a random number and copies to Column B in the same Sheet2

On Sheet1 I have a meeting schedule that requires a meeting password from Sheet2 to be copied to column I

Essentially I must be able to click on a button to auto-fill the password from Sheet2 avoiding any duplicates.

I have attached my Spreadsheet for clarity

Thanks