Pulling information from another wksheet by date

[tonysalas]

I am trying to build a database that I can track due dates with for my patients. What I want to do is be able to put todays date in a cell on page 1 and have all the patients that are over due up to that date show up on the bottom of page 1 pulling patient data stored on page 2. I have started and think I have the formulas close, but something is screwing it up. I can e-mail what I have so far to anyone willing to help.
Thanks for any and all help.

Tony

[Muhammed Rafeek M]

pls mail me with ur file: [email protected]

"tonysalas" wrote:

>
> I am trying to build a database that I can track due dates with for my
> patients. What I want to do is be able to put todays date in a cell on
> page 1 and have all the patients that are over due up to that date show
> up on the bottom of page 1 pulling patient data stored on page 2. I have
> started and think I have the formulas close, but something is screwing
> it up. I can e-mail what I have so far to anyone willing to help.
> Thanks for any and all help.
>
> Tony
>
>
> --
> tonysalas
> ------------------------------------------------------------------------
> tonysalas's Profile: http://www.excelforum.com/member.php...o&userid=36560
> View this thread: http://www.excelforum.com/showthread...hreadid=563097
>
>