Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2016, 05:09 AM
Guloluseus Guloluseus is offline Create Lookahead filter Windows 7 64bit Create Lookahead filter Office 2010 32bit
Competent Performer
Create Lookahead filter
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-15-2016, 08:13 AM
JulieS JulieS is offline Create Lookahead filter Windows 7 64bit Create Lookahead filter Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 02-15-2016, 12:32 PM
Guloluseus Guloluseus is offline Create Lookahead filter Windows 7 64bit Create Lookahead filter Office 2010 32bit
Competent Performer
Create Lookahead filter
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Lookahead filter Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Create Lookahead filter 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
Create Lookahead filter filter kwlickt Excel 1 03-28-2011 11:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft