Macro to update formula

[Dummy Excel]

HI All,

I have a formula:

=((IF(VLOOKUP(Response!$D$14,'Relationship Matrix'!$P$48:$S$58,'Relationship Matrix'!$U$49,FALSE)=1,(1+'KN Rates'!$M14),(1+'KN Rates'!$N14)))*(('KN Rates'!$K14*$G$38)+('KN Rates'!$F14*'Calc Sheet'!$G$35)))+'KN Rates'!$K$30

Although I need to add this to the end of the formula

)/'Exchange Rates'!$C$9

oh and an extra ( after the = sign.

I cant just drag the formula down as some of the reference points are different. Is there a way to update the cell via a macro? or better still highlight the cells that need amending and then run a macro to make those changes only to the hightlighted cells?

thanks
Sam

 

[Dummy Excel]

doesnt anyone want to have a try?