Help to correct a damaged VBA-template

[Netmaster01]

Hi all

In Excel 2013 I found and used a Template for mangaging my projects. The template is called Weekly Time Planner1 and is atached.

In this template, a function is embedded in VBA, that allows for doubleclicking a Projects primary name, and the VB-code shows a filtered view of the assigments in the project in sheet 2.

Problem is, that I added a lot of functions to the template, to make it more usefull to myself - and thereby broke the VB-thing. I thing that its because I added a few columns, that messed it up. And I cant find the right reference in the VB-code to correct.

Thing is, I need this function back - so I desperatly need your help guys.

When I click the Project name ("Projects Overview" - Column B), i want it to filter the Tasks ("Task Details", Column G), based on the name of the project. Function is showed in the "Weekly Time Planner1"-file, in case my description is lost in translation.

Some parts of the file is in danish, hope it dosent matter:-)

/Henrik

[ARGK]

Hi Henrik
See if this is what you need.
All I have done is remove all the current filters on the Task sheet and changed the column number to filter on in the code from 3 to 6.
Good luck.
Tony

[Netmaster01]

THANK YOU!!

I thought that I already tried to change that parameter - but I must have done something wrong. It works like a charm now. Thank you very much!