I have a list of items (by rows) and have sequence of dates (in columns). I want to create a report probably using VBA. I need a list of items that meet the date restriction. For example:
Apple 1/1/2010 2/1/2010 3/1/2010
Orange 1/1/2010 3/5/20010 4/15/2010
Lemon 2/1/2010 3/1/2010
In report, I want to see the output Apple and Orange when I restrict the report to Date=1/1/2010. If I restrict the date range from 3/4/2010 to 3/15/2010, my output should say Orange. I made a "report" using Advance Filter option but I want to make it bit more fancy/user friendly. Any idea??
Apple 1/1/2010 2/1/2010 3/1/2010
Orange 1/1/2010 3/5/20010 4/15/2010
Lemon 2/1/2010 3/1/2010
In report, I want to see the output Apple and Orange when I restrict the report to Date=1/1/2010. If I restrict the date range from 3/4/2010 to 3/15/2010, my output should say Orange. I made a "report" using Advance Filter option but I want to make it bit more fancy/user friendly. Any idea??