close

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=quot;quot;, quot;quot;, {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.

quot;EDquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()