Stephen Kairys
asked on
EXCEL 2003- Filter by Date
Hi,
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.
Many thanks,
Steve
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.
Many thanks,
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Glenn,
Ah, yes I have blank rows! I see what i was doing. This is a list of contacts (for a job search) where I wanted I am using (where needed) multiple rows to record events related to a particular contact. For visual purposes, I separate each contact with a blank line, highlighted in dark blue. i realize, however, this is not really standard use of EXCEL.
So, what I am going to try is to populate the blank rows with dashes or whatever so that they will have data in them. Once I do that, I will try the filtering again.
Thank you for your observant reply! :)
Steve
Ah, yes I have blank rows! I see what i was doing. This is a list of contacts (for a job search) where I wanted I am using (where needed) multiple rows to record events related to a particular contact. For visual purposes, I separate each contact with a blank line, highlighted in dark blue. i realize, however, this is not really standard use of EXCEL.
So, what I am going to try is to populate the blank rows with dashes or whatever so that they will have data in them. Once I do that, I will try the filtering again.
Thank you for your observant reply! :)
Steve
ASKER
OK that worked. In fact, the date I had previously typed 8/25/2014 actually appeared in the dropdown list that includes "(Custom...)".
Points to be awarded momentarily...
Thank you!!
Points to be awarded momentarily...
Thank you!!
ASKER
Thank you Dan and Glenn.
Dan, you get the "primary" points since you provided the correct method.
Glenn, you got me around that roadblock.
As usual, Experts Exchange rocks! :)
Steve
Dan, you get the "primary" points since you provided the correct method.
Glenn, you got me around that roadblock.
As usual, Experts Exchange rocks! :)
Steve
ASKER
that is:
1) Put cursor on the first row (the header) for column M.
2) Chose DATA --> FILTER --> AUTOFILTER.
3) Clicked on the downarrow to the right of col. M.
4) Chose CUSTOM.
5) Then, per the attached screenshot)
selected the field FOLLOW-UP and the date of 08/25/2014. Only one row has this value. However, after clicking OK, most of the rows (except for 2 - 4) remained. What am I missing?
Tks again.
Steve
Excel-auto-filter.bmp