Thanks DonkeyOte, Similar (but ironically the opposite) to darkyam's formula when applying this one it returns every thing as 'Complete' even if its not!

Also what exactly is VBA? I'm very new to this so do struggle with some of the terms!

Thanks again


WTB