I am using a worksheet to ask about 50 questions. I want a piece of code
that will collect all the answers to these questions and put them next to
each other in a single row of a csv file.
Each question has 7 cells/ranges.
For example Q1 is U5,Q6,R6,S6,T6,U6 and B7:U9 - Q2 is
U11,Q12,R12,S12,T12,U12 and B13:U15, etc, etc.
What is the most efficient/quickest way of copying the responses (approx
350) into the csv.

Thanks in advance.

Gareth