Help with filter data

[hercule_p2001]

Hi

I have a worksheet with a list of daily patients that I see. The details among others are: Date, Patient Name, Diagnosis, Follow-up Date, Notes. These are the columns I am interested in and they are not contiguous. As can be guessed, the Date column will be in chronological order. The Follow-up date will have no chronology because some patients may be called after a week, some after 2 weeks, some after a month and some after 3 months.

What I need to so is, set up a filter in such a way that on Sheet 2 of the workbook, if I enter a date say todays' date in cell C2, the data from sheet 1 which match the follow-up dates of Sheet2!$C$2 must be listed in Sheet 2. This will enable me to see the possible appointments I have on any given day without going to Filter Data routine every now and then. Is there a way to do this?

Thanks.

 

[hercule_p2001]

Hi

I got the answer from this forum so consider this issue solved.

http://www.excelguru.ca/forums/showthread.php?330-Which-formula-to-use-for-this...&p=1724#post1724

I am posting the link so that if anyone has a similar problem, they can get the answer and that somebody's time is not wasted trying to figure out the solution.

Thanks.