Hi everyone!
Hope someone can help me.
I have two Excel files inside a sharepoint.
File 1 is a list of several projects. Each line is a different project, which has a unique ID.
ID Project 1 Project1 2 Project2
File 2 is a list of milestones of projects in File 1.
ID Project Milestone % 1 Project1 Milestone1 100% 1 Project1 Milestone2 60% 2 Project2 Milestone1 40% 2 Project2 Milestone2 0%
Is possible to create a link between file 1 and file 2? So when I click on the name of the Project ... file 2 opens, but showing only the milestones of the filtered clicked project?
Best Regards
Bookmarks