Hi all,

Forgive me for the code I have put below but I have typed it out on my iPad as I do not have access to my laptop s the syntax and the full code isn't there but on my actual spreadsheet it's correct.

Dim ws1 As Worksheet
Dim lastrowMaster As Long

    Set ws1 = Sheets("sheet1")
    lastrowMaster = ws1.Cells(Rows.Count, "A").End(xlUp).Row 

 If instr(1, sheets("sheet2").range("a3"), "1") > 0 And instr(1, sheets("sheet1").range("b & lastrowMaster").offset(0, 2).value, "GHS") > 0 

Then

(Do something)

Elseif (same type of if statement with different criteria)

Then 

(Do something)

Else 

Msgbox criteria not met

End if 

End sub
So as you can see it's the if statement with multiple criteria that wasn't working ..

It kept just going to the final else statement where the msgbox said criteria not met.

So the if statement checks a cell on a sheet that has the value one and then check the last record of the other sheet, the value in column c and if it is has the value GHS. IF it meets them both it will do the following action.

I can't see what I am missing.

Maybe it's something silly but I'll try post the proper code tomorrow morning (15 hours from now) if it's something more complicated.

Thank you