Copy a formula to 15 pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to copy the formulas in Columns C to H to the next 15 pages, but
only if there is a number supplied in Column B. If Column B is empty, I
would like C to H to be empty. Is this possible? Thank you.
 
Why not use an If statement in the formula?

Such as...

=IF(B1="", "", {The formula you currently have})

Put this into all of the cells and then the formula will exist but will be
empty if B is empty.

HTH.
 
Back
Top