Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
-
- 2019
- 2010
- 2007
- Platform
-
- Windows
HI All,
I have a formula:
Although I need to add this to the end of the formula
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
I have a formula:
Code:
=((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
Code:
)/'Exchange Rates'!$C$9I 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
