Generate unique number

[adeleex]

Hi all,

Is it possible to have a worksheet which has two buttons one of which generates a number between 1-100 and the other generates one from 101-200?

Many thanks,

Adele

[Macdave_19]

Hi Adele,

Have you used the Randbetween Function Before:

In seperate cells put the following

1-100

Please Login or Register  to view this content.

For the 101-200

Please Login or Register  to view this content.

Then just press F9 to randomly generate the numbers each time

Hope this helps

[Macdave_19]

by the way you'd best be a Leeds fan lol! MOT!

[adeleex]

Should have said the numbers must be sequential so same two aren't used twice and sorry don’t like football!

[ssu95bm]

Hi Adeleex,

I did something similar to this. I had a column in the spreadsheet containing all the previous values (in any order). You can then use this code in your macro:

Please Login or Register  to view this content.

Where X is the column containing all the previous values.

Does that help?

Kind regards,
ssu95bm