Forum

Thanks Mynda. I will check that data and see how I go. Karen

Thank you Mynda. I thought that may be the only way to do it but just wanted to make sure. Karen

Thank you for your help Anders. Works like a dream!

Here are a couple of workbooks. I have put a formula in the Marked Assessments - test in the Note Type column but it is returning a blank instead of a...

Thanks Anders. I was thinking maybe it is a IF and AND function I need to use. E.g. If WS1 column A = WS2 column B and WS1 column C=WS2 column D then ...