Hi folks
Every year I have to generate a list of 4 digit safe codes, for 60 sites, that change monthly. The safe codes cannot have repeating characters.
So I have 60 rows, 12 columns. Each cell must have a code between 0123 and 9876. They need to be randomly generated. It doesn't have to be unique - but the way the safes work is that all 4 numbers within any given code must be different. ie. 1234 is fine 1134 is not.
I've searched high and low for how to do this, and there are lots of threads with advice on how to generate random 4 digit numbers, but none that help with the character repetition. Last year I generated random numbers then manually changed any with duplicate characters. I don't want to do that again this year!
Can anyone help? I can follow instructions but I'm essentially a trained monkey when it comes to VBA code and complicated excel formulas so assume incompetence.
Thanks in advance for any help.
Every year I have to generate a list of 4 digit safe codes, for 60 sites, that change monthly. The safe codes cannot have repeating characters.
So I have 60 rows, 12 columns. Each cell must have a code between 0123 and 9876. They need to be randomly generated. It doesn't have to be unique - but the way the safes work is that all 4 numbers within any given code must be different. ie. 1234 is fine 1134 is not.
I've searched high and low for how to do this, and there are lots of threads with advice on how to generate random 4 digit numbers, but none that help with the character repetition. Last year I generated random numbers then manually changed any with duplicate characters. I don't want to do that again this year!
Can anyone help? I can follow instructions but I'm essentially a trained monkey when it comes to VBA code and complicated excel formulas so assume incompetence.
Thanks in advance for any help.