SharePoint Automation Script in VBA
Budget: ₹600 – ₹1,500 INR
I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks:
- Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive.
- In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard.
- Open another SharePoint Excel file (Excel3) from online and paste the clipboard information.
This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.
- Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive.
- In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard.
- Open another SharePoint Excel file (Excel3) from online and paste the clipboard information.
This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.