Exporting columns from Sheet1 to sheet2
 

Hi,

I need to export some columns from sheet1 to sheet2 with some condition.

For Instance.,

I have DATE, NAME, ID NUMBER, ADDRESS columns in sheet1... I need the data of the NAME column in Sheet2 with the condition.. (In Sheet2-- A1 cell, i have entered the date 8/29/2012. In Sheet2 Column B i should get all the NAMEs from Sheet1 NAME column, having the DATE mentioned in Sheet2 A1 cell, of Sheet1 DATE column)..

Please help me out from this...