aloy78
10-12-2011, 08:28 PM
Hi all,
I would like to run 3 code based ondates/month. I know the auto filter itself does this. But I want to have a morefasterway and more professional look to thereport :)
The first code will (upon click on Cell"E7"):
- show all hidden columns & rows (in case i havemistakenly hidden them, which I always do ;P)
- then filter the cell "Report Date" for data thatwere of last month
Thesecond code(upon click on cell "E8") will does the same function asthe first code except it will filter off data that is off the current month.
Thethrid code (upon click on cell "E9") will prompt out a user form. Theform will require us to key in the start date and end date. Let's say forexample, I would like to search for records in May. So I just key in 01/05/2011and 31/05/2011. Maybe can add in syntax like <, >, =, <=, >=.
I've attached a file for your reference.
I would like to run 3 code based ondates/month. I know the auto filter itself does this. But I want to have a morefasterway and more professional look to thereport :)
The first code will (upon click on Cell"E7"):
- show all hidden columns & rows (in case i havemistakenly hidden them, which I always do ;P)
- then filter the cell "Report Date" for data thatwere of last month
Thesecond code(upon click on cell "E8") will does the same function asthe first code except it will filter off data that is off the current month.
Thethrid code (upon click on cell "E9") will prompt out a user form. Theform will require us to key in the start date and end date. Let's say forexample, I would like to search for records in May. So I just key in 01/05/2011and 31/05/2011. Maybe can add in syntax like <, >, =, <=, >=.
I've attached a file for your reference.