VBA: Help setting up a history table with variables.

Hi There,

Thanks for checking my post!.

I would like to create a history sheet, based on information of a source that updates daily.
there are a couple of variables which I just can't wrap my head around, I have been sleeping really bad for days now...

This is the situation:

"Source that updates daily" is a data set that comes from the ERP System (see workbook attached)
The ID is a production order and the date is the day it should be completed.
Because the Date of production can shift due to sickness or other things, I would like to know how many day's it shifted from the last entry(I will do that via excel)

I will also explain what exactly needs to happen:

Lookup each ID in history, If not found -> make a record in History and Offset the Date beside it.

Next: If a match was found inside history, check if the date in the source Equals the last entry inside History.
If the date is the same,
Do nothing

If the date is not the same, Offset the new known date beside the old date cell.

than the cleanup of History
If ID in history is not found inside the source, Delete the ID and all the dates stored beside it.

I Can explain what I have been trying to do:
This is all I have because I keep getting stuck with what method to use best/trying to make the method work and fail.

Please help I'm exhausted!

Please Login or Register  to view this content.

wow thanks man, for taking the time!
this is incredible.!

Many, many thanks!

Done! thanks so much again !

may life give you all the best

the piece of code provided by nankw83 is perfect.
this is solved. thanks for taking the time to respond