EXCEL 2003- Filter by Date
Posted on 2014-08-21
I have EXCEL (2003, hoping to upgrade soon). I have a workbook containing several sheets. One of them has a column FOLLOW-UP date. (This is a list of people, some of whom I need to contact on a specific date.)
Every morning (hopefully w/o having to write a macro to do so) I would like to be able to show just the rows that have that date in the FOLLOW-UP column.
I would rather type in the date rather than have it default to today's date.
I then need to seamlessly revert to the normal view of this sheet.
I tried using the FILTER function but did not get that far with it.
EDIT: If a potential solution is to insert a new sheet in the workbook, and pull the filtered data from the source sheet that would be awesome.
So, if anyone can help, it would be greatly appreciated.