Excel - Copy down formula if cells non-blank

October 2016


I need code to copy down a formula from R2 to R3, R4, R5 etc only if H3, H4, H5 etc is non-blank.
  • I also need to copy formulae from U2:CY2 to U3:CY3, U4:CY4 etc only if S3, S4 =1


You can use if statement as a wrapper for you function

, put your formula here)

Note that

Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Excel - Copy down formula if cells non-blank » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.