Hi everyone, hope someone can help:

I have a worksheet called "data" which contains a range of values, ro
A contains the header values and the data within the sheet has th
defined name "database".

I have another sheet called "Report", which contains in cell B1 a dro
down list of all the known dates in the "data". cell B2 contains a dro
down list of all the known "Names" in the "data" worksheet.

What I would like to do on the sheet called "report" is bring acros
all the data which matches the values selected in cell B1 and B2.

Let me know if that isnt explained well.
Thanks for your time
Love Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=56019