Show list of customers that have not ordered

[jeff_miller]

I have 4 reports that I get
The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date
The 4 reports are
Orders for the last two years
Orders for the last Month
Orders for the last 3 weeks
Orders for the last two weeks

I would like to drop all four of these reports into a different tab on a worksheet and add a fifth tab that would list the following
Customers who have ordered in the last two years but not in the last two weeks
Customers who have ordered in the last two years but not in the last three weeks
Customers who have ordered in the last two years but not in the last One Month

Any ideas?
I dont want to use Conditional formatting and highlighting as I would have to manually look for the customers who had not ordered for that time period.

 

[jeff_miller]

https://www.dropbox.com/s/zsx8267o4...last two Years 2018-11-20T1102 test.xlsm?dl=0

 

[Fluff]

The Customers in the "Last Month" sheet all have spaces after the name.
This means that they are not in the dictionary & so you get the same values for 3 & 4 weeks.

 

[jeff_miller]

Thank you Fluff! It is always the little things with me....
I removed the space(s) and am now getting a compile error, expected end sub? The last line in the code is highligted blue ""End With"?

 

[Fluff]

Add End Sub after the End With

 

[jeff_miller]

Thank You, Thank You, Thank You!!!

 

[Fluff]

You're welcome