Hi,

I am totally stuck. I have an excel spreadsheet, and I want to do the
following

On Sheet2 field A2 is 23/11/2009.

I have a spreadsheet with lots of information in, and i want to find all
items that the date is 23/11/2009 and populate a new table. I want to display
actual data.
I am trying to set this up to run from a macro that has a pop up box to
enter the date. I can get the macro to work with a pop up box and I can get
it to pull one line with a vlookup, but I don't know how to pull mulitple
data.

Please help me!