collect data from sheet and put into one row of csv file
 

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

collect data from sheet and put into one row of csv file
 

Hi,

I believe this is a cross post, we discourage that.

Without code use =A1&B1&X5 .....

You can record the formula for code.

--
Thanks,
Shane Devenshire


"Gareth" wrote:

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

collect data from sheet and put into one row of csv file
 

ShaneDevenshire

I don't believe it is a cross post.

Also I think I didn't explain my problem clearly, all of the cells relaing
to the questions need to go into row 3 of another sheet starting at A3 and
moving across to IV3 with any remaining ones going onto row 4 starting at A4.

Gareth

"ShaneDevenshire" wrote:

Hi,

I believe this is a cross post, we discourage that.

Without code use =A1&B1&X5 .....

You can record the formula for code.

--
Thanks,
Shane Devenshire


"Gareth" wrote:

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