I am trying to simplify a KPI data entry process within my department. Members are required to update the same KPI in multiple sheets per month which is causing confusion and missed deadlines.
I would like to create a survey where the KPI information can be entered once per month, then that entry can be accessed by multiple spreadsheets to automatically update the data in the spreadsheet (eliminating the need of many members needing to access many spreadsheets at the same time).
I am able to create the survey, I just can’t figure out how to access that data from another excel spreadsheet automatically without having to export the results, and manually update each sheet myself?
Any insight into how to do this would be much appreciated! Thank You!
(I am currently using Sharepoint 2010 and do not have access to Sharepoint Designer here at work)
