mercredi 1 décembre 2021

Excel VBA Random Number Generator Based on a Range and Generate 5 sets in rows by Transpose using a command button

I've been looking all over the internet and couldn't find anything based on my specific question. They're either one or the other solution but not combined.

As per my title, I'm looking for a way to generate 5 rows

"(By Transpose) (if a number can be entered in a cell to specify the number required to be generated that would also do) "

of random numbers to be taken from a Range AA14 of already generated distinct values. This Range increases as new values get added on the table where it gets its values from.

Each row must not have any duplicates and if ever possible should not be identical to the rows below after result generation.

Im doing this over a vba & command button as it is more convenient to generate results.

https://docs.google.com/spreadsheets/d/1BNMC_CNsrSqhmce0JYeaJgFB511NbQHC/edit?usp=sharing&ouid=114325811391032934372&rtpof=true&sd=true




Aucun commentaire:

Enregistrer un commentaire