I have 8 questions (A - H) and 5 answers per question (1 - 5) - so a total of 40 possible answers.

Using PERMUT(8,5), I know there are 6,720 permutations of answers.

I now need to fill a matrix of 840 rows and 8 columns (Question ID) with the 6,720 permutations.

I want to fill them with an Answer ID (there are 40 answers) - A1, A2, A3, A4, A5....B1, B2, B3, B4, B5....and so on,.

Does anyone have a solution to this? Ideally, I would like a formula as opposed to VBA as I'm a little out of my depth when it comes to VBA code. However, I'll take whatever I can get!

Thanks in advance.