Excel Workbook Automation to SharePoint
Budget: $15 – $25 AUD
I have an Excel workbook that contains raw timesheet data. I need this to be organized primarily into an employee table. Once the data is in the Excel workbook, I need to automate the transfer of this data to a SharePoint list.
Key Requirements:
- Excel: Arrange raw timesheet data into an employee table.
- Sharepoint: Manually triggered data transfer from Excel to SharePoint.
- Data Processing: Before transferring, there must be calculations for Summation of hours worked, Calculation of overtime, and the processing of mileage and expenses.
Skills/Experience Needed:
- Proficient in Excel to organize raw data into specific tables.
- Experience working with SharePoint for data transfer.
- Competency in data processing, particularly around time and expense calculations.
Please note that the data transfer from Excel to SharePoint must be manual, so I'm looking for someone who can set up a user-friendly trigger for this process.
Key Requirements:
- Excel: Arrange raw timesheet data into an employee table.
- Sharepoint: Manually triggered data transfer from Excel to SharePoint.
- Data Processing: Before transferring, there must be calculations for Summation of hours worked, Calculation of overtime, and the processing of mileage and expenses.
Skills/Experience Needed:
- Proficient in Excel to organize raw data into specific tables.
- Experience working with SharePoint for data transfer.
- Competency in data processing, particularly around time and expense calculations.
Please note that the data transfer from Excel to SharePoint must be manual, so I'm looking for someone who can set up a user-friendly trigger for this process.