itdgoodridge
New Member
- Joined
- Feb 15, 2013
- Messages
- 1
Hello everyone,
I have a table connected to a survey hosted on SharePoint. As new responses are added to the survey they are brought into excel. In the same workbook on another worksheet I convert the answers from the survey into values, tally the values and determine an overall score.
Being new to excel's advanced features, I am unsure as to how I can link these two tables so that as new survey responses are added the database linked table they create a new row in my conversion table.
ex. Table A - database connected table has the response "Customer Facing"
Table B displays the value "3", at the end column I add the values and give the survey response a percentage score
=IF('BSS Results'!C2="Customer Facing",3,IF('BSS Results'!C2="Revenue Producing",2,IF('BSS Results'!C2="Internal Operation",1)))
Hope this helps, any advice would be great!
I have a table connected to a survey hosted on SharePoint. As new responses are added to the survey they are brought into excel. In the same workbook on another worksheet I convert the answers from the survey into values, tally the values and determine an overall score.
Being new to excel's advanced features, I am unsure as to how I can link these two tables so that as new survey responses are added the database linked table they create a new row in my conversion table.
ex. Table A - database connected table has the response "Customer Facing"
Table B displays the value "3", at the end column I add the values and give the survey response a percentage score
=IF('BSS Results'!C2="Customer Facing",3,IF('BSS Results'!C2="Revenue Producing",2,IF('BSS Results'!C2="Internal Operation",1)))
Hope this helps, any advice would be great!