Transfering data from sheet to another sheet using arrays

[YasserKhalil]

Hello everybody
I have two sheets : Data sheet and Results sheet
My attachment is just a sample..the original has large amounts of data
I could loop through cells in sheets("Data").range("b2:B" & Last row) to check for the date which is in Result sheet. range("C2") to extract the data related to that date

I need to use arrays as I know it is faster and realiable in dealing with large amounts of data

Thanks for help