Hi All

I am trying to create an item in excel that when selected it will take the variable open up a project plan (in Microsoft project) and filter and the specified variable

So basically, my excel spreadsheet would look like this

Item # Description Owner
1234 Title 1 Joe Bloggs
5678 Title 2 Some Guy

And I would have a project plan that looked like this

Item # Task Resource Start Date End Date
1234 Start Work Resource 1
1234 Report on Work Resource 1
1234 Review Work Resource 2
1234 End Work Resource 3
5678 Provide Budget Resource 4
5678 Review Budget Resource 1
5678 Approve/Decline Budget Resource 5

Basically what I would like to know is if something can be created that would do the following:

A user selects Item 1234 in the excel spreadsheet

Item # Description Owner
1234 Title 1 Joe Bloggs
5678 Title 2 Some Guy

When the click on the cell holding the value a macro is run that opens up the project plan and filters on Item # to only display 1234 and thus the below information will be displayed in project

Item # Task Resource Start Date End Date
1234 Start Work Resource 1
1234 Report on Work Resource 1
1234 Review Work Resource 2
1234 End Work Resource 3

Thanks in advance