January 30, 2020
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
December 20, 2019
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)
November 1, 2018