Rand Help

Originally Posted by Bryan Hessey

hmm, another Rand

http://www.excelforum.com/showthread.php?t=584304 has a shuffle, which will shuffle 105 items each time you press CTRL/SHIFT/S
Put the required numbers in column A and you can then select from Sequence!E1 downwards from the list.

hth
---amended, let me adjust this to your needs

shouldn't repeat along the row in the first block, nor down the column in the second

hth
---

Thanks for the replies. I am learning more everytime I open excel! I have never messed with the VB stuff, so that is all real new to me. Bryan, in your script, what are my keys to assign row/column to distribute the numbers from the Sequence sheet? I tried to pick it apart to look for the obvious things (A2, etc.) but couldn't figure out how it goes. Is there an easy way to explain this, or is there a tutorial that you can recommend so I can learn a little?


Thanks agian!

(I'd upload my sheet, but it's larger than 100KB & I'm at work so can't get to hosting sites. I'll try to upload tonight when I get home. It has several pool type projects I am working on.)

Originally Posted by kingsolo

Thanks for the replies. I am learning more everytime I open excel! I have never messed with the VB stuff, so that is all real new to me. Bryan, in your script, what are my keys to assign row/column to distribute the numbers from the Sequence sheet?

I tried to pick it apart to look for the obvious things (A2, etc.) but couldn't figure out how it goes. Is there an easy way to explain this, or is there a tutorial that you can recommend so I can learn a little?


Thanks agian!

what is the question? - the book opens into a Sheet1 that displays just one cell, CTRL/Shift/S

What to allocate is Column A of the sheet 'Sequence', put whatever you want in column A and it gets shuffled, for you I used numbers.
Anything starting with z is ignored.


as for tutorials, the http://www.danielklann.com/tutorials/tutorial_index.htm is one of many that get shown here often.

---

Originally Posted by kingsolo

I am trying to get everything from the file you sent into my file, then get it to put into the formatted sheet that I have. The Row/Column numbers I used in the example were just an example. I just need to get the numbers into the proper boxes in the sheet I already have built. My fault for not clarifying that in my earlier post. I will look at that tutorial and see what i can glean from it. Thank you so much for your help.

Hi,

you will probably find it easier to Copy the two sheets into your workbook and put links

=Sheet1:A2

etc to pick up the random display.

hth
---

Originally Posted by kingsolo

Here is a link to the project... too big to post here.

http://www.sharebigfile.com/file/47072/Pool.xls.html

I will see if I can figure out what you mean and get the sequence 10 file moved over.

Thanks.

from the point that you need do this only once per Square setup, then Scott's suggestion of Copy and Paste Special = Values is by far your best option.

Record a macro whilst you do that, and put another shortcut key to it.

However, do you not also have a requirement that 'random' numbers in the first row are not in the same relative position in the first Column ?
for each row/column pair?

ie
F2 & B6
F3 & C6
F4 & D6
F5 & E7

or, does F3 & C6 both being = 8 cause you no problem?

hth
---