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

Attached Files

Mac_Zoom Meetings Schedule - Copy - Copy.xlsm (31.5 KB, 7 views)