Need to generate random choice at top of a column

K

Ken Burgin

Hi - here's what I need to do - can you assist?

I want to have a column of different words with a button at the top , when I
click on the button it will 'spin' the column and display one of them
randomly at the top. It will only choose from the cells below that have data
in them (not empty ones). How do I write a macro to do this? I then want to
have about 6 of these columns side by side with a 'master button' that will
spin all of them at the same time, generating a random set of six words.

Any assistance greatly appreciated...

Ken Burgin
Sydney
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Password Generation 0
Random table of data - need to find every cell that contains specific data 1
MS Project Center-Autolink column fields 0
Need formula to randomize employee numbers for history audits 1
Help with formula 0
HOW-TO make a random selection from a set of data and divide it into sub-team 2
Move Chart with Text 0
Generate Correlated variable to an existing data set 1

Top