Generating a Random List of Questions & Answers - VBA?

I suspect that this might be quite easy for you VBA pros, but here goes!

I have a file with two columns laid out thus:

Excel 2016 (Windows) 32 bit

	A	B
1	Q1	A1
2	Q2	A2
3	Q3	A3

Sheet: Sheet1

Column A contains questions and column B contains answers. I want to be able to enter my pairs of Qs and As and then, at the push of a button, generate random pairs of answers and questions thus:

Excel 2016 (Windows) 32 bit

	C
1	A3
2	Q1
3
4	A1
5	Q2
6
7	A2
8	Q3

Sheet: Sheet1

The list of Qs and As needs to be any length - usually between 16 and 24 rows of data. The random output needs to ensure that no matching pair ends up together.

Any ideas?

Duplicate posing

I think this will do what you want.
You should adjust the ranges to suit.
If you want less than all the questions in the result, adjust the Size variable.

Please Login or Register  to view this content.

The OP asks to randomize the question/answer pairs. (And then re-arrange them into a column.) The OP request (as I read it), does not change the correspondence between a question and its answer.

Maybe :

Please Login or Register  to view this content.