Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Excel
I have been trying to conditional move the contents of a spreedsheet within
an IF statement without any luck any answers? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Excel
Hi
An example will help, thanks "DonE" wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
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. "Eduardo" wrote: Hi An example will help, thanks "DonE" wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
Hi Don,
Right click in the mouse, copy go to the other sheet paste "DonE" wrote: 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. "Eduardo" wrote: Hi An example will help, thanks "DonE" wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
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. "Eduardo" wrote: Hi Don, Right click in the mouse, copy go to the other sheet paste "DonE" wrote: 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. "Eduardo" wrote: Hi An example will help, thanks "DonE" wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
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 "DonE" wrote: 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. "Eduardo" wrote: Hi Don, Right click in the mouse, copy go to the other sheet paste "DonE" wrote: 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. "Eduardo" wrote: Hi An example will help, thanks "DonE" wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Excel
On Mon, 1 Jun 2009 07:44:02 -0700, DonE wrote:
I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
On Mon, 1 Jun 2009 07:57:01 -0700, DonE wrote:
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. 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 ---------------------------- --ron |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
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. "Ron Rosenfeld" wrote: On Mon, 1 Jun 2009 07:44:02 -0700, DonE wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? 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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
On Mon, 1 Jun 2009 15:53:01 -0700, DonE wrote:
An example would be: This IF Statement is in Sheet2 at C1 IF(Sheet1!A1=1,Sheet1!B1:B17,IF(Sheet1!A1=2,Sheet 1!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. 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,Sheet 1!C1,"")) Then fill down to Sheet2!C17 --ron |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
does any one know to copy cells within an IF statement in Exce
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,Sheet 1!C1,"")) Drag/copy down to C17 Gord Dibben MS Excel MVP On Mon, 1 Jun 2009 15:53:01 -0700, DonE wrote: An example would be: This IF Statement is in Sheet2 at C1 IF(Sheet1!A1=1,Sheet1!B1:B17,IF(Sheet1!A1=2,Sheet 1!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. "Ron Rosenfeld" wrote: On Mon, 1 Jun 2009 07:44:02 -0700, DonE wrote: I have been trying to conditional move the contents of a spreedsheet within an IF statement without any luck any answers? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel If statement copy only if ISNumber result is yes | Excel Worksheet Functions | |||
IF statement on a range of cells in Excel 2007 | Excel Worksheet Functions | |||
copy cells from multiple pages to one sheet w/ if statement | Excel Worksheet Functions | |||
I need an If statement for Excel that excludes empty cells | Excel Worksheet Functions | |||
If statement...copy values of cells on another worksheet. | Excel Discussion (Misc queries) |