IF Statement for copying multiple cells if argument true

**saeed9313** · 10-02-2012, 09:54 AM

Hi

I am trying an IF statement which should copy multiple cells if argument is true. For example I am in B2 and if A2=A3 then I want data from A10 to A20 in B2 to B12. Hopefully I was able to clarify the situation. Thanks!

**Fotis1991** · 10-02-2012, 09:59 AM

Hi

Maybe in b2 and drag down.

=IF($A$2=$A$3,A10,"")

**saeed9313** · 10-02-2012, 02:39 PM

But this will copy just one cell, I need to copy that whole row i.e. A10 to A20. And then I will drage down to C2 and so on. Thanks!

**Fotis1991** · 10-03-2012, 01:44 AM

Originally Posted by saeed9313

But this will copy just one cell, I need to copy that whole row i.e. A10 to A20. And then I will drage down to C2 and so on. Thanks!

No. If you drag(copy) down the formula, will copy range A10:A20, TO b2:b12.

...I need to copy that whole row i.e. A10 to A20. And then I will drage down to C2

A10:A20, ISN'T one row..

Would you like to upload a small sample workbook, to show us what do you mean?

IF Statement for copying multiple cells if argument true

LinkBack

Thread Tools

Rate This Thread

Display

IF Statement for copying multiple cells if argument true

Re: IF Statement for copying multiple cells if argument true

Re: IF Statement for copying multiple cells if argument true

Re: IF Statement for copying multiple cells if argument true

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions