Copy data from one sheet to another if the date is equal or higher than a gien date

[ANDREAAS]

Hi

i have a workbook with 3 sheets where i want the values of the rows in one sheet to copy to another sheet if the rows date is equal or higher than a certain specified date which will change weekly. see attached workbook.....

if a date in column A of the "Data Entry" sheet is equal or higher than the date in cell B1 of the "This weeks tyre changes" sheet, i want the corresponding data in the row in the "Data entry" sheet where the same or higher date is found to copy to the next open row in the "this weeks tyre changes" sheet at the press of a button.......

[ANDREAAS]

the file i am referring to, attached

[ANDREAAS]

Bump no response

[Fotis1991]

An ARRAY formula can do this too!

Please Login or Register  to view this content.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.