Copy a formula to 15 pages

E

ED

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.
 
D

DaveO

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Copy and Paste Word 2010 0
Autonumber field in Excel that behaves the same as Access 0
List all tables, including document structure 0
Getting a formula to reflect added columns 10
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Insert Index into a Table 1
Help with lots of formulas 3

Top