I've got a list of Projects with multiple unique month values. What I want to do is take Jan data and compare to the Feb data (same file layout, just different dates) to see if people are changing Feb data after it was entered in Jan. Did they change targets after they were already locked in? In example below, I'd expect the fields below in Red to be flagged as changed. Would expect a Vlookup on the Feb Tab looking at the Jan Tab, but having issues with having multiple lines with Same Project ID. All help appreciated.
[TABLE="width: 1058"]
<tbody>[TR]
[TD]January Data Tab[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]February Data Tab[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Project[/TD]
[TD][/TD]
[TD]Sales Target[/TD]
[TD]Sales Confirmed[/TD]
[TD][/TD]
[TD]Project[/TD]
[TD][/TD]
[TD]Sales Target[/TD]
[TD]Sales Confirmed[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jan[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Jan[/TD]
[TD]50[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Feb[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Feb[/TD]
[TD]40[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mar[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Mar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Jan[/TD]
[TD]100[/TD]
[TD]90[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Jan[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Feb[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Feb[/TD]
[TD]100[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mar[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Mar[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mar[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Apr[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Apr[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]June[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]June[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1058"]
<tbody>[TR]
[TD]January Data Tab[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]February Data Tab[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Project[/TD]
[TD][/TD]
[TD]Sales Target[/TD]
[TD]Sales Confirmed[/TD]
[TD][/TD]
[TD]Project[/TD]
[TD][/TD]
[TD]Sales Target[/TD]
[TD]Sales Confirmed[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jan[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Jan[/TD]
[TD]50[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Feb[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Feb[/TD]
[TD]40[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mar[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Mar[/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Jan[/TD]
[TD]100[/TD]
[TD]90[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Jan[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Feb[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Feb[/TD]
[TD]100[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mar[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Mar[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Mar[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Apr[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Apr[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]June[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]June[/TD]
[TD]75[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: