Moving column data from one worksheet to rows in another worksheet.

[taichi56]

This one is really confusing to me. I have a daily call log which has various data. I have to take certain data from certain columns and put them in the "daily call log on a certain row. Much of the data is just counting how many names or yes or no there is. But the daily call log needs to have the data from column "O" from the daily call log put in as data separated by commas. I put explaintions in the Daily summary sheet of where the data is suppose to come from. Not sure even how to start putting the data from one sheet into another sheet. Did some searches and tried but failed. Hope someone can help. Thank you. I attached the workbook. The second sheet has the explanation of what I need.

[FDibbins]

Im not sure what you want or from where, so maybe this will get you headed in the right direction.

based on Daily Summary Sheet...
in C3
=COUNTA('Call Summary Sheet - 8 Jul 13'!D2:D1000)
adjust this for other places you want a simple count
In C9
=COUNTIF('Call Summary Sheet - 8 Jul 13'!T:T,"Yes")
change Yes to No to count NO's

Can you provide a sample of what you want for row 8?

[taichi56]

Yes thank you. Row 8 will take all the data from column "O" in Call summary sheet and put them in the row with commas, like so:

300, 111, 167, 266, 16.

Thank you for your help.

[FDibbins]

OK, try this.

I added a helper column on sheet1 column Z and ised this, copied down from Z2...
=IF(COUNTA(A2:Y2)=1,"",IF(O2="",Z1,Z1&IF(Z1="","",", ")&O2))In Z1 enter ' (the do-hickey on the " key)
then on sheet1, row 8, use this...
=INDEX('Call Summary Sheet - 8 Jul 13'!Z:Z,SUMPRODUCT(--('Call Summary Sheet - 8 Jul 13'!Z:Z<>""))+2,1)

[taichi56]

Ok, I copied the code from Z2 on down to row 8 and that gave me all the data in one row separted by commas. How do I get it to the next worksheet in the proper row? Thank you.