How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 32073
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have created a job application online using excel survey.

Customer Question

I have created a job application online using excel survey.
I need to print each submission to view it. Is there nice way to auto send me via email each form or setup a pivot table to display each submission.
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Rachel-Mod replied 3 years ago.

Hello,

I'm a moderator for this topic. I've been working hard to find a professionals to assist you with your question , but sometimes finding the right professionals can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!

Customer: replied 3 years ago.
Still need help. My online app is found here. Jobs.jollygoodsweets.com
Expert:  Rachel-Mod replied 3 years ago.

Thank you for your patience. We will continue the search for a professional for you.

Rachel

Customer: replied 3 years ago.
Great. Thnx
Expert:  Richard replied 3 years ago.
Thank you for your question, my name is Richard.

I am really sorry about the delay. The fact the file is online makes it very hard to achieve this as you are using Excel in a way not really designed.

Have you looked at www.surveymonkey.com ?

This I think is what you need. It is specifically designed to collect information, and display this in a variety of different ways, also exportable to excel.

It is also highly customizable. You can check it for free, and let me know please if this does not meet your needs.

Thank you
Customer: replied 3 years ago.

I think the best answer is to create a pivot table to display the information for each submission. The pivot table should be able to display select info but I was hoping there was a template or example of a pivot table. Also, I could display the info in a word doc and link the data.

Expert:  Richard replied 3 years ago.
ok, show me the file with the survey results please

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 3 years ago.

just use this link and you can download or edit. if you download or copy it, let me know and I will delete it from the world. thanks.


http://sdrv.ms/10LP211

Expert:  Richard replied 3 years ago.
ok, looking now
Customer: replied 3 years ago.

Awesome and thanks

Expert:  Richard replied 3 years ago.
ok, The way the data is currently, not really inn this file.

If you want to do reporting, have you looked at importing it into Microsoft Access and making a report from it?

Do you have Microsoft Access installed?

Customer: replied 3 years ago.

Sorry,


but you are just not an expert in this topic.


Please refund. I have figured it out.