Run A Macro

[gmazza76]

Good Afternoon,

I am trying to automatically populate some cells depending on a drop down.

The drop down is in cell "B2" on Sheet1.

I am using the code below to enter the names etc... but am unsure of how to assign it to change when Cell "B2" does
I know the code looks promative but it is the only way i can think of doing it as the file is shared and i cannot use AutoFilter due to this

If "B2" = "Atiff Mazhar" Then
 
    B4 = "Carolyne Anderson"
    B5 = "Charlotte Ryalls"
    
End If

Many Thanks
Gavin

 

[CWatts]

=IF(COUNTA($E$4:E4)<FONT COLOR="RED"><COUNTIF</FONT>(B:B,$E$3),INDEX($C:$C,MATCH($E$3,$B:$B,0)+COUNTA($E$4:E4)),"")