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 1Q1 A1 2Q2 A2 3Q3 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 1A3 2Q1 3 4A1 5Q2 6 7A2 8Q3
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?
Bookmarks