filter few customized columns by date or date range AT ONCE

[Majid]

I have 5 customized date columns per each project ( in one row) and I have
about 200 projects.
each column has deliverable date inserted. So, for each project I should
have 5 deliverable dates at different time interval.
How can I filter all 5 columns at once for a particular date or date range?
right now i can filter one column at the time
Perhaps I should write VBA code that is able to filter all projects by the
date or range of the interest?
Please advise
Thank you for your help

 

[John]

I have 5 customized date columns per each project ( in one row) and I have
about 200 projects.
each column has deliverable date inserted. So, for each project I should
have 5 deliverable dates at different time interval.
How can I filter all 5 columns at once for a particular date or date range?
right now i can filter one column at the time
Perhaps I should write VBA code that is able to filter all projects by the
date or range of the interest?
Please advise
Thank you for your help

Majid,
You could probably just use a series of "Or" statements or "Or" and
"And" statements (for a range) in a filter. I personally might opt for a
VBA approach simply because I find it more flexible.

Hope this helps.
John
Project MVP

 

[Majid]

Hi John,
Thanks for the response
I believe also the VBA code is easiear to manage. I am not sure if I can
write the code John. Perhaps I need a VBA code to filter all the dates for
next 10 days that are written in these custom fields? If this is possbible
would be awesome!
Please advise

 

[John]

Hi John,
Thanks for the response
I believe also the VBA code is easiear to manage. I am not sure if I can
write the code John. Perhaps I need a VBA code to filter all the dates for
next 10 days that are written in these custom fields? If this is possbible
would be awesome!
Please advise

Majid,
I'm a little confused. You say you believe VBA code is easier to manage
yet you say you cannot write what would be a fairly simple macro. If I'm
out of line here I apologize, but it sounds like you are looking for
someone to "do your homework".

If VBA is out of scope, why not start with the structure of the built-in
"Date Range" filter and modify it to do what you need, as I suggested in
my first reply.

John

 

[Majid]

Well John you make me to write it but it is not my expertise to write the
macro and my fear is not to be able to complete it.
What do you think?

 

[Majid]

Hi John,
I just want to add, problem using "or" and "and" filter is that i cannot
define the current date in the value section for i.e i want to say to filter
"text 1" when is "equal or greater than" the current date.
By doing this I can filter specific projects for that specific date from all
5 text fields
Please advise Thank you Majid