Hi,

Please could any one prepare a macro for me with following details:

I have data base of about 100 questions divided into various groups. I want
a macro where in every time I get a set of randomly selected 20 questions
representing questions from all the groups.

In column B: I have Name of various groups
In column C: I have questions, there could be 5-6 questions in each groups
(there should be flexibility as there can be any number of questions in each
groups ranging from 1 to 25-30)

I want a question paper for a student in a new excel file.

There should be a flexibility in terms of number of questions available in
data base. There could be 80 as well as 150 any number.
There should even be flexibility in selecting number of questions required
for a particular student.

Cheers,
Mandeep Dhami

Hello,

Maybe this helps:
http://groups.google.co.uk/group/mic...08291 08c7eae

HTH,
Bernd