does any one know to copy cells within an IF statement in Excel

  • Thread starter Thread starter DonE
  • Start date Start date
D

DonE

I have been trying to conditional move the contents of a spreedsheet within
an IF statement without any luck any answers?
 
I would like based on a IF condition to move the contents of a row in one
sheet to another sheet, effectively copying the contents of an existing sheet
to the new location in the new sheet.
 
I need for the copy to be conditional within an IF Statement. I'm trying to
move cells from three different rows to a single row based on the contents of
a third cell.
 
Hi,
You didn't provide and example what will really helps however try

=If(a1="Yes",A3+A4+A5,"")
A1 is the cell that you want to compare with
A3,4 & 5 are the 3 cells to summarize
If A1 is different to yes it will leave a blank space

Hope this was the answer you were looking for
 
I have been trying to conditional move the contents of a spreedsheet within
an IF statement without any luck any answers?
Click to expand...

A function can only return a value. It cannot move the contents of one cell to
another.

Perhaps if you could be more specific about what you are trying to accomplish
....
--ron
 
I would like based on a IF condition to move the contents of a row in one
sheet to another sheet, effectively copying the contents of an existing sheet
to the new location in the new sheet.
Click to expand...

You cannot move the contents of a cell, or a row, with a function. A function
can only return a value.

Perhaps:

If your original data is on sheet1!A1:Z1

And you want the new data to be on sheet2!A2:Z2

Then in A2 enter a formula of the type:

=if(conditional_test,sheet1!A1,"")

then fill right to Z2
 
An example would be:

This IF Statement is in Sheet2 at C1

IF(Sheet1!A1=1,Sheet1!B1:B17,IF(Sheet1!A1=2,Sheet1!C1:C17," "))

What I'm trying to do is based on a variable in Sheet one move a row of data
from sheet1 to sheet2 based on informatin in sheet1. The above example would
move 17 cells to this location on sheet2 from C1 to C17.
 
An example would be:

This IF Statement is in Sheet2 at C1

IF(Sheet1!A1=1,Sheet1!B1:B17,IF(Sheet1!A1=2,Sheet1!C1:C17," "))

What I'm trying to do is based on a variable in Sheet one move a row of data
from sheet1 to sheet2 based on informatin in sheet1. The above example would
move 17 cells to this location on sheet2 from C1 to C17.
Click to expand...

Doesn't make sense as written. What ROW are you trying to MOVE?

If you are really trying to COPY a COLUMN (and not really MOVE a ROW), then see
if this works:

Change your formula in Sheet2!C1 to:

=IF(Sheet1!$A$1=1,Sheet1!B1,IF(Sheet1!$A$1=2,Sheet1!C1,""))

Then fill down to Sheet2!C17


--ron
 
B1:B17 and C1:C17 are columns of data, not a row of data.

A formula cannot move cells as Ron stated. You must use VBA to move things
or enter a repeating formula.

In C1 of sheet2 enter

=IF(Sheet1!$A$1=1,Sheet1!B1,IF(Sheet1!$A$1=2,Sheet1!C1,""))

Drag/copy down to C17


Gord Dibben MS Excel MVP
 
Back
Top