Compare 2 sheets then delete data but only if dates longer than 7 days

[tweacle]

What im trying to do is look in sheet called download and compare against data in sheet called Tableau.

Im comparing data in columns A-D in each row. The data wont be a match line against line on the 2 sheets and it will need to search all down the columns. If the data is in sheet called download but NOT in sheet called TABLEAU then I need that row deleting from the sheet called download, BUT any dates that are all in column C in the workbook called download are within the last 7 days of when the download done I need them ignoring and staying in workbook.

What I mean is if I do a download say today and I compare all the data. Any data that has a date after 7th April I need ignoring and just keeping in the sheet called download. I then need that to happen on a rolling thing every time I do a download.

[tweacle]

I think ive explained it too complicated and may of found easier way if anyone can advise.

I think that it way be easy as every entry will have a unique time and date in column K and a unique value in column J but im no tech expert.

Would it work if you looked in book 2 at the value and date and time in columns J & K and compared them with book 1 Column K and column D? if the value was missing from column D then it needs deleting?

There will be loads of entries all down the workbook but the layout is the same,

[Mumps1]

Is the data in two separate workbooks or on two separate sheets in the same workbook? What are the sheet names?