JonnyBT123
New Member
- Joined
- Jul 23, 2018
- Messages
- 14
Hi all,
Sorry if this is not in the right place.
Does anyone know if a workbook which has been saved to a SharePoint library can populate a column in the library using a cell in the workbook?
I have a simple test for interviewees to complete, and there is a hidden 'results' tab with $T$10 having the result as a percentage in it.
I can save the completed xlsx file to Sharepoint no problem,but is it possible to set up so that a column I have created in the librarycalled ‘Result’ can be populated with Sheet(“Result”).Range(“T10”) of each andevery file which will be saved from interviewees completed forms?
Using Excel 2013 & Sharepoint 2010 (full admin rights to SP.)
Any help appreciated, or pointing in the right direction J
Sorry if this is not in the right place.
Does anyone know if a workbook which has been saved to a SharePoint library can populate a column in the library using a cell in the workbook?
I have a simple test for interviewees to complete, and there is a hidden 'results' tab with $T$10 having the result as a percentage in it.
I can save the completed xlsx file to Sharepoint no problem,but is it possible to set up so that a column I have created in the librarycalled ‘Result’ can be populated with Sheet(“Result”).Range(“T10”) of each andevery file which will be saved from interviewees completed forms?
Using Excel 2013 & Sharepoint 2010 (full admin rights to SP.)
Any help appreciated, or pointing in the right direction J