I want to write a macro which would check the value of cells in column f and fill column g, h and I cells if condition is met and this is for the entire column range.
The column f in total has 3 different values.
Say if- cell in column f has value x then I want column G cell to have AAA, column h cell to have BBB and column I to have CCC.
Similarly if Column F cell has value y then G, H and I to have AA, BB, CC respectively.
Can any one help me out please.