Hello!
I would like to expand this code to check more than one cell.
If in Sheet2 cell H16 or H17 or H18 or H19 or M16 or M17 or M18 or M19="ABC"value and cell AD10=312A or 312B to add text in Sheet3.
If the conditions are met to add some text.
Thanks a lot for your help.
this is what I have, it works but it checks sheet2 and one cell (m16) only.
If Sheet2.Range("m16").Value = "ABC" Then
Select Case Sheet2.Range("ad10").Value
Case Is = "312A", "312B"
Sheet3.[e16] = "Attn..."
Sheet3.[a16] = "INFO"
End Select
End If
blue
Bookmarks