select words randomly.

Hi

I know excel can generate random numbers,

Can someone guide me how i can create random word generator.

I have list off word in sheet 2 column A, Column B, Column C and Column D from row 1 to 60,000.

In sheet 1 i want to press next button and word is selected form sheet 2 and displayed in a cell BUT no word is displayed again if it was displayed once.

I am creating this file for school as one of the teached wants to do spelling test on kids, i though a file would make it easier.

hope someone can help out.

An idea just to get you started:

You could use a pair of RANDBETWEEN() functions in a pair of cells.
The first would be between 1 and 4
The second would be between 1 and 60,000

Then use an INDEX() function that references those 2 cells

=INDEX(Sheet2!A1:D60000,cell with higher rand,cell with smaller rand)

Now every time you hit F9 the two random numbers will generate a return from your 4 column table.

I'll let a VBA expert tell you how you you can use a macro to record each return and use a check to see if a word has already been used - if so, do another random generation