I am relatively new to Macro, so rather from writing it, I use Macro recording.
After pressing the hot key (Crtl + Shift + P), the first advanced filter works.
It is based on A B C D columns and generates 4 new columns, F G H I, based on the criteria of E1 and E2.
The second filter does not work.
Second advanced filter is based on the unique of Column G and generate into Column K.
However, this filter only generates the header (the column title) but no data. When I do it manually, there are header as well as filtered data.
Does anyone catch any mistake in the code? I have researched online for a long time, but I still cannot figure out why it works manually but not in macro.
Thank you for the kind considreation,
' NEWFILTER Macro
' Keyboard Shortcut: Ctrl+Shift+P
Please Login or Register to view this content.