#1
|
|||
|
|||
Create Lookahead filter
I am trying to put together a filter that will produce a lookahead programme, but does not rely on data from special columns.
The required filter will show; tasks that start between 7 days before a user input date and a point 21 days past it (now-7 to now+21) tasks that start between 7 days before a user input date and a point 21 days past it (now-7 to now+21) Tasks that start more than 7 days prior to the date, and end more than 21 days after it. this would show all tasks starting, finishing or carrying through the 4 week spread of -7/ +21 days from the user input. I can manage this using columns, as I can use the "current date" function, from which I can produce the filter. However the filter really needs to be a standalone that works from a user input date due to restrictions I wont go into now. I know I can use an input ("Date to set as start"?) but can I then use the input throughout, or do I have to put a new value in for each calc? Thanks all. |
#2
|
|||
|
|||
You can prompt for data, but you'll need to re-input the data every time. The only other method would be to develop something using code (VBA) where you could capture in the input and pass it through to other filters.
Out of my skill set - but if you have some skills with VBA - you could try posting to the Technet Forum https://social.technet.microsoft.com...ct2010custprog |
#3
|
|||
|
|||
Thanks Julie
I might just keep columns and leave them as hidden- found out today that I need to produce a new template for projects so it may well be the easiest way to go with it. Ill try the link as it will be useful, also gain me a few kudos points at work! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge from excel - need to create sheets and create a table | bluenosebex | Mail Merge | 5 | 08-02-2015 05:34 PM |
Newbie q - Create a filter for report in ms project 2013 task due in 2 weeks | bypm | Project | 7 | 07-10-2015 06:19 AM |
how to filter using hyperlick? | nicholes | Excel Programming | 20 | 04-16-2015 03:54 AM |
Apply filter with VBA | bobsawyer7 | Outlook | 0 | 03-12-2012 04:02 AM |
filter | kwlickt | Excel | 1 | 03-28-2011 11:15 AM |