Excel - Copy down formula if cells non-blank

Ask a question


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.

Excel - Display Formula in Cell
Calculate Time Between 2 Dates in Excel