Vba how to set this value cell in my value ?

Hi,

i have done an example drop down where if user select drop down list A they be given to select based on the grouping, now however i want to target this column cell value as = 1 of my drop down

i have put the instruction down in the excel marco can someone help me out from the vba to add on this ?

i have try this vba code

If Target.Value = "3G" Or Target.Value = "4A" Or Target.Value = "4B" Or Target.Value = "4C" Or Target.Value = "4H" Or Target.Value = "4K" Or Target.Value = "4P" Then
Range(valueC, Range(Target.Address)) = "Sale (Default)" ' Target column C 
End If