Log In
Register
Home
Power Query
January 30, 2020
Offline
Hi,
Im building A Hazard report with VBA. In my Excel Dump TAB I have an advanced filter that will interact with various criteria ("AH") which really works well in VBA.
However, Im a bit confused on how to use the criteria "Date Of Incident" ("I2") which has inputted at various dates.
What I want to do is use this column as an advanced filter the Months. So if there was various inputs for February, I want to able to use criteria ("AH2") change the criteria heading Date Of Incident and use the word Month to filter those months out.
Can any one suggest anything for me on this ...Im getting stumped on this.
The macro shortcut is CTL-Shift-D
Thanks
steve
Trusted Members
December 20, 2019
Offline
Hi Steven
The attached is a .xlsx so not a macro workbook and therefore no code in it.
You are using A to AF as the data dump and AH as the criteria? With the output in columns AJ to BO?
Not sure having the data, criteria and output all on one sheet is ideal as the whole row will be filtered.
Can you upload again with your code (.xlsm)
Purfleet
Trusted Members
Moderators
November 1, 2018
Offline
By the sounds of it, you want a formula for the criteria, in which case you don't want the criteria header cell to match any columns (better to leave it blank) and then use a formula like =MONTH(I2)=2 to restrict to February.
1 Guest(s)
