Sean15
Wellknown Member
 Joined
 Jun 25, 2005
 Messages
 654
 Office Version

 2019
 Platform

 Windows
In H6, I have the formula below:
IF(H5="","",IF(C6="MATCH",H5*0.25,""))
When the match criteria is met, Excel does calculation in H6.
When match criteria is not met, user enters number in H6.
This is all ok, but when worksheet is reused, formula is lost in H6, H7, …
I’m assuming VB will be required. Could someone share VB codes or another way to fix problem?
Regards,
Sean
IF(H5="","",IF(C6="MATCH",H5*0.25,""))
When the match criteria is met, Excel does calculation in H6.
When match criteria is not met, user enters number in H6.
This is all ok, but when worksheet is reused, formula is lost in H6, H7, …
I’m assuming VB will be required. Could someone share VB codes or another way to fix problem?
Regards,
Sean