Excel Automation with Power Automate
Budget: ₹1,500 – ₹12,500 INR
I'm looking for a skilled freelancer with expertise in Power Automate for Excel 365 to help me automate a workflow. The task is to split a single Excel file into multiple ones based on the value in the 'Department' column.
Key Tasks:
- Automating the workflow of splitting the Excel file
- Syncing the original file with data added in the new files
- Implementing restrictions to user access by limiting editing permissions
- Teaching me how all this is done
The ideal candidate for this project should be proficient in:
- Power Automate
- Excel 365
- Data management
- User access control in Excel
Please note: The splitting will be based on the 'Department' column, and I need the original file to sync with the new files as data is added. I am looking for someone who can not only complete the task but also explain the process to me in a clear and understandable manner.
Key Tasks:
- Automating the workflow of splitting the Excel file
- Syncing the original file with data added in the new files
- Implementing restrictions to user access by limiting editing permissions
- Teaching me how all this is done
The ideal candidate for this project should be proficient in:
- Power Automate
- Excel 365
- Data management
- User access control in Excel
Please note: The splitting will be based on the 'Department' column, and I need the original file to sync with the new files as data is added. I am looking for someone who can not only complete the task but also explain the process to me in a clear and understandable manner.