Moving and massaging data

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!
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top