Hello

Can you copy and paste more than one formula at a time? In this instance Im
referring to a work sheet has 3 IF statements; one for Monday through till
Friday is the same, while both Saturday and Sunday have different IF
statements respectively. Is there away to accomplish the copying and pasting
of all three IF statements simultaneously?

Kind regards


Tim

Assuming that you mean the formula for Monday through Sunday are in
consecutive columns or consecutive rows, then the formula can be
highlighted and formula-dragged, or can be copy & paste special =
formula together.

ie. if cell B2 has Monday's formula, C2 has Tuesday's formula etc up to
H2 with Sunday's formula, select C2:H2 and you can then drag the small
square in the bottom right corner of the highlight.

Beware of copying split ranges, the formulas may not be what you expect
in the copy. You cannot formula-drag a split range.


Tim Wrote:
Hello

Can you copy and paste more than one formula at a time? In this
instance Im
referring to a work sheet has 3 IF statements; one for Monday through
till
Friday is the same, while both Saturday and Sunday have different IF
statements respectively. Is there away to accomplish the copying and
pasting
of all three IF statements simultaneously?

Kind regards


Tim


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487725

Thanks for your response Bryan but unfortunately it didn't work, it simply
copied the the one IF statement (the one relating to Monday -Friday). Maybe
it's because of a split range. Would you mind explaining this to me please?

"Bryan Hessey" wrote:


Assuming that you mean the formula for Monday through Sunday are in
consecutive columns or consecutive rows, then the formula can be
highlighted and formula-dragged, or can be copy & paste special =
formula together.

ie. if cell B2 has Monday's formula, C2 has Tuesday's formula etc up to
H2 with Sunday's formula, select C2:H2 and you can then drag the small
square in the bottom right corner of the highlight.

Beware of copying split ranges, the formulas may not be what you expect
in the copy. You cannot formula-drag a split range.


Tim Wrote:
Hello

Can you copy and paste more than one formula at a time? In this
instance I€„¢m
referring to a work sheet has 3 IF statements; one for Monday through
till
Friday is the same, while both Saturday and Sunday have different IF
statements respectively. Is there away to accomplish the copying and
pasting
of all three IF statements simultaneously?

Kind regards


Tim


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487725