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