schakarian
Programmer
Hi,
In Excel I have a drop down list that has each month as an item to select from.
The data looks like the following:
Item Jan Feb Mar Apr ...
ABC x x
DEF x
GHI x x x x
When a user selects a month from the list, a macro runs to filer the column(month) selected and display all items that have an x. (ie. if "Feb" is selected items DEF and GHI are displayed.)
I would like to add a YTD item to this list. I don't have a problem with identifying what the current month is and creating if statements accordingly, but my problem is the following: How can I specify multiple criteria on the Autofilter with having them ALL be valid? If i'm in Feb and choose YTD, I want to select all items that have JAN = x "OR" all items that have FEB = x (DEF and GHI above)...
Sorry for the long post, any help is appreciated.
In Excel I have a drop down list that has each month as an item to select from.
The data looks like the following:
Item Jan Feb Mar Apr ...
ABC x x
DEF x
GHI x x x x
When a user selects a month from the list, a macro runs to filer the column(month) selected and display all items that have an x. (ie. if "Feb" is selected items DEF and GHI are displayed.)
I would like to add a YTD item to this list. I don't have a problem with identifying what the current month is and creating if statements accordingly, but my problem is the following: How can I specify multiple criteria on the Autofilter with having them ALL be valid? If i'm in Feb and choose YTD, I want to select all items that have JAN = x "OR" all items that have FEB = x (DEF and GHI above)...
Sorry for the long post, any help is appreciated.