Hi,

Many thanks the reply.

The attached file shows Sweeps and the other sheets, is the codes, we upload every week.

The Weekly codes, need to somehow, lookup the Sweeps sheet and any code that is present to the weekly codes, is to check if they can run alongside each other.

As an example:
534199 16SPM from Row 2, can run with 537503 SPM from Row 20, as the Sweep data sheet shows this.

i hope that makes sense.

Many thanks

Pugg