To handle different numbers of questions, try the attached.

Attached Files

ash6540 -Solution to Problem.xlsx (13.9 KB, 11 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you very much for your reply - it works ok, sorry about the delay to your prompt response.

The only trouble I am finding is the question format in the import sheet is not always consistant, this is due to the mixture of English and Arabic text. Sometimes the text flips back to front on the import sheet (as arabic is read right to left). So makes it difficult to use as an absolute reference to count on. I was novicely experimenting with Loops because another sheet in the same workbook contains the number of questions. My theory was to do a loop on the cell range in relation to the number of questions (calculate, copy and paste the data into the table) and do it 3 times (once for each response area). But I haven't been able to achieve that

If you or anyone else has any futher suggestions on how to tackle this problem it will be greatfully received???.