Paste by Date & Time

Hi,
I have 2 worksheets each with identical column names A=date, B:E=floats

I'm trying to paste data from one worksheet "newdata" into another "data".
I only want to paste the row if the date(column A) from "newdata" is greater than the last date in "data"

From reading other posts I've written the following, but this seems to only copy and paste the same rows from "data" on top of existing rows. I want it to paste dates that are later than 08/19/13 14:30:00 from new data into data.

Please Login or Register  to view this content.

Any help would be greatly appreciated. Thanks in advance.
intrday_paste_test.xlsm

Thank you very much, this is excellent.