Hi all,
My workplace keeps a SharePoint List as a tracker of all incoming work requests on our 'new work form' which is an Excel sheet.
The problem is that an employee has to sit an manually read the information from the excel sheet and then type the necessary information into the relevant fields on the SharePoint list.
Is there a way to set something up so that the new work form can be 'read' by the SharePoint and the relevant fields extracted into the SharePoint from the excel list?
(I know one answer could be to just allow the person writing the new work form to write directly into the SharePoint but this creates control issues)
Thanks!!!
My workplace keeps a SharePoint List as a tracker of all incoming work requests on our 'new work form' which is an Excel sheet.
The problem is that an employee has to sit an manually read the information from the excel sheet and then type the necessary information into the relevant fields on the SharePoint list.
Is there a way to set something up so that the new work form can be 'read' by the SharePoint and the relevant fields extracted into the SharePoint from the excel list?
(I know one answer could be to just allow the person writing the new work form to write directly into the SharePoint but this creates control issues)
Thanks!!!