Hi,
i am new to VBA and wants to do the following:
I have a database in sql server 2008. In this db there is a table that got the results of a survey.
It only registers the number of a question and the number of the answer and a contact id.
So what i am about to do is, i export the result data from that table into the Excel 2010 workbook in an Excel worksheet that already excist.
Now in this workbook there are several worksheets that contain the text of all te questions and Answers with there numbers.
So how can i get the right Question with the right answer for the right contact id?
Example:
Customer 1: contactid = 0001 his/her question is "Are you satified with the service delivered?" Her answer is Very Satisfied.
Question has number 1 and answer has number 5
Questions are at tab/sheet Questions
And Answers are at tab/sheet Answers.
How can I get this information in one row at the worksheet Survey with VBA?
Thanks
Wim81
Bookmarks