gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
I want to modify this. I no longer need it to look over 7 to see if it equals "Phantom". So I need to take that part out. Just check over 2 columns and see if its a "Y" if so change G to "FLST"
but now I need it to put the "FLST" in column F not G
THANK YOU!
but now I need it to put the "FLST" in column F not G
THANK YOU!
Code:
Sub Find_FloorStock()
'Author: G Heyman 190221
'Update "Type" Find Floor Stock and change from B to F"
'E is the Make/Buy 2 over is the FloorStock
With Range("G5", Range("E" & Rows.Count).End(xlUp))
.Value = Evaluate(Replace("if((@=""B"")*((" & .Offset(, 7).Address & "=""Phantom"")+(" & .Offset(, 2).Address & "=""Y"")),""FLST"",@)", "@", .Address))
End With
End Sub