Copy a formula to 15 pages
 

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.

Copy a formula to 15 pages
 

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.

"ED" wrote:

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.