View Single Post
 
Old 03-26-2014, 04:48 AM
ash6540 ash6540 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2014
Location: Abu Dhabi
Posts: 4
ash6540 is on a distinguished road
Default Almost works

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???.
Reply With Quote