Pulling information from another wksheet by date
 

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

Pulling information from another wksheet by date
 

pls mail me with ur file:

"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