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

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

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