Hello,

We need your help to solve one problem. Two VBA scripts are needed.

1. Copy unique random rows from Sheet1 to Sheet2 as calculated in cell C1. Enter the copy rows date in Sheet1 D columns (example in green). It would be great if this script could be run only once or the script could be disabled.

2. Transfer one random number from Sheet1 to Sheet3 without transferring to Sheet2 sheet (without dates). Enter the copy rows date in Sheet1 D columns (example in blue). This step could be done several times.

I put together Sheet2 and Sheet3 to get the results I want.

Sorry for my English

Excel 202308.xlsx