Random from multiple lists

[Edu_Puixa]

Hello!

This is my first time posting hear, though I have been using this forum for quite some time now.

I am creating multiple-choice quiz. I have variety of topics I use e.g. physic, math, material science, etc. At the moment I have all these topics in one big list (one column) so I can easily pick random questions, but this setup is not handy when I need to add new questions to certain topic or delete some. Now I would like to separate each topic in different sheet or column (if in one sheet) - doesn't make a big difference in VBA.

I have attached sample file with my idea. Here I have:

• Question numbering for five different topics (columns A to E) each topic with different question count;
• 100 questions in total from which I use 10 in quiz
• Range G5:K5 shows theoretical number of questions from each topic (depending on question quantity in each topic)
• Range G6:K6 shows actual number of questions from each topic (J6 indicates that at least 1 question is from each topic, I6 number is decreased as it is the largest topic)
• Range G9:P11 shows 10 questions. "Alpha" list is primary and "Beta" list is what I want to achieve.

I have idea how to make "alpha" list, when random questions follows topic groups.
But I have no idea how to randomize all 10 questions "Beta" list. Do I need to make it similar as in my sample sheet? Create "Alpha" list array and then randomize it? Or is there easier way?

Any help will be much appreciated!

Random list quiz.xlsx

[Bob Flanagan]

You might want to take a look at the Flash Card Assistant. It is free and does lots of what you want. I wrote it for my daughter.

http://www.add-ins.com/flash-card-assistant.htm

[Edu_Puixa]

You might want to take a look at ....

Thanks Bob. I checked your add-in and it is great for its intended purpose - flash cards! Possibly in your code there is something I am looking for - random data from multiple sheets. Problem with your add-in is that that I have 2..5 answer options depending on question.

Besides that I want to get through this and learn something new! Thats why I'm asking for suggestions/directions