Forum Discussion
MicrosoftNewbie121
Feb 02, 2024Brass Contributor
VBA Find and update values if the ID Match
Hello, i would like an example of VBA code please to search an ID from a Sheet2 (in ID list column B) if it matche the ID list column B in Sheet1 then (if found) copy value of column F Sheet2 and pas...
- Sep 20, 2023
Hi john john,
it's possible to link Microsoft Project management into SharePoint Online and it's a great way to improve collaboration, visibility, and reporting for your projects.
Here are two ways to link Microsoft Project and SharePoint Online:
- Sync with a SharePoint tasks list: This method allows you to sync a Microsoft Project plan with a SharePoint tasks list. This means that changes made to the project plan in Microsoft Project will be reflected in the SharePoint tasks list, and vice versa. This is a great way to keep everyone on the same page and ensure that everyone is working on the right tasks at the right time.
- Add Project Online to a site collection: This method allows you to add Project Online to a SharePoint site collection. This will create a new Project Web App site within the site collection. You can then use Project Web App to manage projects and tasks. This is a good option if you need more robust project management features than what is available in SharePoint.
Whichever method you choose, linking Microsoft Project and SharePoint Online can be a great way to improve your project management process.
You can use these links as a reference:
Sync with a SharePoint tasks list - Microsoft Support
Add Project Online to a site collection - ProjectOnline | Microsoft Learn
Microsoft Project and SharePoint: The Perfect Combination for Collaborative Project Management - MPUG
https://www.brightwork.com/sharepoint-templates/project-management-templates
https://learn.microsoft.com/en-us/office/troubleshoot/project/sync-with-tasks-from-projectPlease click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
NikolinoDE
Feb 02, 2024Gold Contributor
- MicrosoftNewbie121Feb 02, 2024Brass ContributorSorry for disturbing just found how to do this 🙂 thank you so much
Editing this line change everything
wsUpdated.Cells(matchingID + 1, "F").Value = updatingIDCell.Offset(0, 6).Value - MicrosoftNewbie121Feb 02, 2024Brass ContributorHello NikolinoDE that is working perfectly, can you please teach me how can i apply this example to update Owner 1 Column please ?