| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell function to copy contents of another cell
What I want to do: create a cell function that will - if cell = quantity 0
then copy worksheet 1 cells a2 to c2 and paste that information to worksheet 2 cells a2 to c2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell function to copy contents of another cell
Functions can only return values, they can't directly affect (i.e.,
paste to) other cells. So in worksheet 2, cell A2, enter =IF(x = 0, 'Worksheet 1'!A2, "") where x is your "cell" reference. Copy that across to worksheet 2, cell C2. In article , Margo wrote: What I want to do: create a cell function that will - if cell = quantity 0 then copy worksheet 1 cells a2 to c2 and paste that information to worksheet 2 cells a2 to c2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell function to copy contents of another cell
Thanks. I couldn't see the tree for the forest, your formula worked, all I
had to do was add in the worksheet name as well the cell. "JE McGimpsey" wrote: Functions can only return values, they can't directly affect (i.e., paste to) other cells. So in worksheet 2, cell A2, enter =IF(x = 0, 'Worksheet 1'!A2, "") where x is your "cell" reference. Copy that across to worksheet 2, cell C2. In article , Margo wrote: What I want to do: create a cell function that will - if cell = quantity 0 then copy worksheet 1 cells a2 to c2 and paste that information to worksheet 2 cells a2 to c2 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell function to copy contents of another cell
One guess ..
Assume quantity is listed in D2 in Sheet1 In Sheet2, Put in A2: =IF(Sheet1!$D2="","",IF(Sheet1!$D2=0,Sheet1!A2,"") ) Copy A2 to C2 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Margo" wrote: What I want to do: create a cell function that will - if cell = quantity 0 then copy worksheet 1 cells a2 to c2 and paste that information to worksheet 2 cells a2 to c2 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell function to copy contents of another cell
Thanks, that answer set me on the right path. I just had to create an IF
formula in each cell on sheet 2 that returned the content of the cell on sheet 1. "Max" wrote: One guess .. Assume quantity is listed in D2 in Sheet1 In Sheet2, Put in A2: =IF(Sheet1!$D2="","",IF(Sheet1!$D2=0,Sheet1!A2,"") ) Copy A2 to C2 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Margo" wrote: What I want to do: create a cell function that will - if cell = quantity 0 then copy worksheet 1 cells a2 to c2 and paste that information to worksheet 2 cells a2 to c2 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell function to copy contents of another cell
welcome, glad it helped
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Margo" wrote in message ... Thanks, that answer set me on the right path. I just had to create an IF formula in each cell on sheet 2 that returned the content of the cell on sheet 1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy the contents of every 10th cell? | Excel Discussion (Misc queries) | |||
| copy cell value not contents | Excel Discussion (Misc queries) | |||
| Copy contents to cell based on value in second cell | Excel Discussion (Misc queries) | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| What worksheet function will formatlessly copy cell contents? | Excel Worksheet Functions | |||
Hybrid Mode
