I can do a find and replace in VBA, but I'm not sure how to write this one with the If thrown in.
Basically what I need to do is: IF Column H.Value = TravelMeal OR Vehicle Shipping
Then
IF Column G.Value = "18 MDX" Then Update Column G.Value = "2BJ"
Else Do Nothing.
There are many instances where Column H is either TravelMeal or Vehicle Shipping, But I only want to change the value in Column G if it is currently 18 MDX and the former is true.
Hope that makes sense, appreciate any help!
Bookmarks