PDA

View Full Version : Feedback form Help



Mattstarky
06-01-2010, 02:19 AM
Hi guys, been a bit of a lurker here for a few months, but im unable to grasp what i'm looking for. I'll try to explain the best i can

I need to get feedback from customers during a flower trial i am conducting

I'll explaint eh basic process

1. Flowers get sent to select people, and an email gets sent to the customers with an excel feedback form, which is very outdated, and is just static. with a question and answer sort of thing.

I have redesigned this form and have put in yes/no option buttons with 12 questions.

Once they recieve the bouqet they fill in the form and send it back.

I need to make a dashboard that i can simply browse for the returned excel feedback sheet and then, just read the yes no values from the form and put them into a new spreadsheet.

I'm struggling with even the basics of the dashboard.

I'm not sure how to read the values really.

Any help would be much appreciated.

I'm using Excel 2003 if that helps.

Thanks

Matt

Bob Phillips
06-01-2010, 02:55 AM
ARe you saying that you want to automatically transfer the responses from the feedback form(s) to you dashboard workbook sheet? How many will there be, will they all be open, how many times will you solicit feedback, etc.?