I have a query regarding something I’m not sure is possible. Hopefully somebody can tell me whether that is the case or not.
We have an Excel document that we issue to suppliers after an audit, outlining the findings raised on each line. Each line has the following columns:
• Finding number
• Finding description
• Finding raised date
• Corrective action (supplier completes this)
• Corrective action planned completion date (supplier completes this)
Is it possible to have that Excel spreadsheet linked to a list in SharePoint? So for example once that sheet is completed (or half completed) and stored in a document library another list library can extract the pertinent information and store it in a list? This list would then consolidate all the individual spreadsheets into a reportable format once they had been uploaded?
I’m struggling to get the link between a spreadsheet and a list? Not sure it is possible?