Hello-
I am an administrator for my work's SharePoint site. We have numerous Excel docs in the SharePoint which contain quality data. I am looking to see if anyone knows how (or if) I can add another excel document in the SharePoint, which would automatically populate data from specific cells in other excel docs located in the same SharePoint site.
For example:
Each Excel document has a final % number located in a specific cells. I would like to have that final % number automatically pull over into a separate excel doc that than has an accumulation of each docs final % number.
Say I have 40 stores, each one has its own Excel doc on the SharePoint, within each document it has a specific cell that has 'total # widgets'. I want to create a new excel doc with a list of the 40 Stores, that automatically pulls the 'total # widgets' from each other document.
Can this be done, if so how? Thanks!
I am an administrator for my work's SharePoint site. We have numerous Excel docs in the SharePoint which contain quality data. I am looking to see if anyone knows how (or if) I can add another excel document in the SharePoint, which would automatically populate data from specific cells in other excel docs located in the same SharePoint site.
For example:
Each Excel document has a final % number located in a specific cells. I would like to have that final % number automatically pull over into a separate excel doc that than has an accumulation of each docs final % number.
Say I have 40 stores, each one has its own Excel doc on the SharePoint, within each document it has a specific cell that has 'total # widgets'. I want to create a new excel doc with a list of the 40 Stores, that automatically pulls the 'total # widgets' from each other document.
Can this be done, if so how? Thanks!
