Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel formatting - include count of survey responses

Posted on 2014-02-07
16
347 Views
Last Modified: 2014-03-13
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
0
Comment
Question by:andymacf
  • 7
  • 6
16 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39842038
Is this what you want ?
gowflow
Sample-V9.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39842066
ok
0
 
LVL 7

Author Comment

by:andymacf
ID: 39842233
Hi gowflow

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

Thanks
Andy
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 29

Expert Comment

by:gowflow
ID: 39842606
@byundt
How do you suggest this would be treated ? As this is a follow on previous question
gowflow
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39842713
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
 
LVL 7

Author Closing Comment

by:andymacf
ID: 39842980
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
 
LVL 29

Expert Comment

by:gowflow
ID: 39843067
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
 
LVL 7

Author Comment

by:andymacf
ID: 39866839
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
 
LVL 29

Expert Comment

by:gowflow
ID: 39866847
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
 
LVL 7

Author Comment

by:andymacf
ID: 39867073
Hi gowflow

here you go, new question
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39867121
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
 
LVL 7

Author Comment

by:andymacf
ID: 39895371
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
 
LVL 7

Author Comment

by:andymacf
ID: 39926330
Hi gowflow

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

Regards
Andy
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Formatting code for Excel Forms 17 48
Need Help with Mapping and Toggling 3 21
Need Help with Mapping ONLY 9 24
Conditional formatting excel 5 12
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question