Morning,
I have some data split as previous months data & current months data, what i need to do is;
- Validate both sets of data against each other to make sure the references we have from previous month we have on current month
- Any references that are not on current month but are on previous month need to be highlighted on differences sheet with a source id
- Any references that are on current month but are not on previous month need to be highlighted on differences sheet with a source id
- The references for validation are column B (Asset ID Code)
I have attached my workbook for example.
Regards
Bookmarks