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
Bookmarks