Hello,
How would I go about VBA code for multiple:
if cell in Range("C10:C27") contains string X then make cell on left value Y
if cell in Range("C10:C27") contains string X1 then make cell on left value Y1
if cell in Range("C10:C27") contains string X2 then make cell on left value Y2
How would I go about VBA code for multiple:
if cell in Range("C10:C27") contains string X then make cell on left value Y
if cell in Range("C10:C27") contains string X1 then make cell on left value Y1
if cell in Range("C10:C27") contains string X2 then make cell on left value Y2