Excel formatting - include count of survey responses

Hi Experts

Further to a previous question, Previous post, I would like to expand on the solution to include a count of recorded responses on the final 'Charts' worksheet.

This information should be labelled 'Responses' and should appear in the top right corner of the worksheet just beneath the empty title field.

Thanks
Andy
LVL 7
andymacfAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Brad

Thank you very much for clarifying what need to be done. I take it that there are two corrective action that need to take place.

1) Asker (and I am not pointing here to actual asker but asker in general) should post a sample workbook that is the basis of supporting document for the question. In  this case we cannot blame asker as it is clearly indicated that it is a follow to a previous question that has an attach workbook. But note is taken for future.

2) the solution provided has the workbook with the changes and yes it is quite intricate for someone who does not know the issue to know what was changed and how and for this I take full responsibility and will bring corrective action.

Thank you for noting this which will ensure well taken into consideration in future posts.

@andymacf

in the Sub CreateCharts here are the changes to the previous version you had:
I declared a variable Resp as long

I added after instruction
MaxRowChart = MaxRowChart + 1

this line
Resp = Resp + 1

and added after this line
Next I

these 3 lines
'---> Place total Resonses in I2
WSCharts.Range("I2") = "Responses: " & Resp
WSCharts.Range("I2").HorizontalAlignment = xlRight

This should do it. File updated attached.
Regards

gowflow
Sample-V10.xlsm
0
 
gowflowCommented:
Is this what you want ?
gowflow
Sample-V9.xlsm
0
 
gowflowCommented:
ok
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
andymacfAuthor Commented:
Hi gowflow

This is the correct information but could it possibly be displayed beneath the empty title row.

Thanks
Andy
0
 
gowflowCommented:
@byundt
How do you suggest this would be treated ? As this is a follow on previous question
gowflow
0
 
andymacfAuthor Commented:
Perfect, thanks gowflow.

Apologies for the difficulties caused with one of the fellow experts.  Is there anything I need to be aware of when posting future questions regarding my formatting.

Cheers
Andy
0
 
gowflowCommented:
No I think you do fine as you fine as you clearly state what you need and you post workbook. I think its me who should over and above posting the final solution explain to whoever will read the post what was the solution proposed and what is the piece of code that was added and where so it is clear straight out what is the solution.

We should always remember that EE is an excellent forum where you can have specific questions and straight answers with a big panel of highly Experts that you cannot find anywhere on the web.

I personally use EE very often for my business developments and even when I have hard time finding solution and go on the web, I finally end up finding my solution back in EE. We wee need to keep this in mind both Experts and askers that the issue we are facing could also help lots of people reason why transparency and clearness is a must.

Tks your grades and feel free to post a link for any future question you may need help with.

Regards
gowflow
0
 
andymacfAuthor Commented:
Hi gowflow

It seems that the response total is not working correctly.  In the example posted, there are 65 responses, yet only 34 show in I2 on the Charts sheet.

Can you have a look please?

Thanks
Andy
Survey-Reports-MASTER-v10.xlsm
0
 
gowflowCommented:
This question has been closed. I will be more than happy to assist you with any question you may need help with. Simply post a link for the new question here and will be glad to assist.
gowflow
0
 
andymacfAuthor Commented:
Hi gowflow

here you go, new question
0
 
gowflowCommented:
I see you have 2 accounts ?
andymacf
JCIE

will you be using both ? just for tracking purposes. I usually file all answers I give per the asker so I can follow at any time later and have the latest solution given.

If you will keep both no problem for me.
gowflow
0
 
andymacfAuthor Commented:
Hi gowflow

EE have merged my 2 accounts so i will be posting under andymacf from now on.

A New Question if you are keen to help.

Cheers
Andy
0
 
andymacfAuthor Commented:
Hi gowflow

I have opened a new question which you may be able to apply your skills to

Regards
Andy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.