Gathering Comments from Survey Data
 

I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:

Jan-07 5 5 3 3 4 4 Comments
Feb-07 4 3 5 5 4 3 Comments
Feb-07 3 2 3 2 3 4
Mar-07 1 5 5 5 5 5
Mar-07 2 3 4 3 4 3 Comments

The months are Dates, the first of each month to be exact and the Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the summary
running down other then using a pivot table. When I did use a table it
stretched the summary table out of whack. Even if I can only show one month
at a time it would be OK.

Thanks for your time and thoughts!

Gathering Comments from Survey Data
 

Hi Brian,

Probably the easiest way to do this is VBA, however it can be done with a
formula approach, although its quite involved. Which approach would you
prefer?


--
Thanks,
Shane Devenshire


"Brian H" wrote:

I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:

Jan-07 5 5 3 3 4 4 Comments
Feb-07 4 3 5 5 4 3 Comments
Feb-07 3 2 3 2 3 4
Mar-07 1 5 5 5 5 5
Mar-07 2 3 4 3 4 3 Comments

The months are Dates, the first of each month to be exact and the Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the summary
running down other then using a pivot table. When I did use a table it
stretched the summary table out of whack. Even if I can only show one month
at a time it would be OK.

Thanks for your time and thoughts!

Gathering Comments from Survey Data
 

I have been trying to avoid VBA, but I would take ether. We have a lot of
staff who tinker with VBA and get into the code on shared docs a change them
for the better. So far I have a nice locked down file.. :-)


"ShaneDevenshire" wrote in
message ...
Hi Brian,

Probably the easiest way to do this is VBA, however it can be done with a
formula approach, although its quite involved. Which approach would you
prefer?


--
Thanks,
Shane Devenshire


"Brian H" wrote:

I have raw survey data in a table on a single sheet. The data is the
month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month
and
the question data. Example:

Jan-07 5 5 3 3 4 4 Comments
Feb-07 4 3 5 5 4 3 Comments
Feb-07 3 2 3 2 3 4
Mar-07 1 5 5 5 5 5
Mar-07 2 3 4 3 4 3 Comments

The months are Dates, the first of each month to be exact and the
Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the
summary
running down other then using a pivot table. When I did use a table it
stretched the summary table out of whack. Even if I can only show one
month
at a time it would be OK.

Thanks for your time and thoughts!

Gathering Comments from Survey Data
 

Drat, new update...
The data table has changed. Each row will now include a name on it.
We will be needing to limit by the names. (I guess I missed a memo)

"Brian H" wrote in message
news:4B7Eh.1138344$R63.177466@pd7urf1no...
I have raw survey data in a table on a single sheet. The data is the month
the survey was done followed by a few survey ratings then a comment. Some
surveys come back with out a comment so those lines are just the month and
the question data. Example:

Edited Data
Bob Jan-07 5 5 3 3 4 4 Comments
Bob Feb-07 4 3 5 5 4 3 Comments
Bill Feb-07 3 2 3 2 3 4
Bob Mar-07 1 5 5 5 5 5
Bill Mar-07 2 3 4 3 4 3 Comments

The months are Dates, the first of each month to be exact and the Comments
are unlimited (at this time) text fields.
I have a summary sheet that is showing the totals by month running across
the sheet. What I would like to do is gather the Comments under the
summary running down other then using a pivot table. When I did use a
table it stretched the summary table out of whack. Even if I can only show
one month at a time it would be OK.

Thanks for your time and thoughts!