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.
- Nov 18 Sat 2006 20:10
Copy a formula to 15 pages
close
全站熱搜
留言列表
發表留言