| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I automatically copy cell contents from one cell into anot
This can't be very hard, but I can't find out the best way to do this, I
need to copy the contents of a cell, from one cell, into another cell, in a different sheet on the same workbook. I do not need to copy the formula, what would be the best approach... Its almost like a form fill operation, a label. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I automatically copy cell contents from one cell into anot
Select the Sending cell
Rightclick on it and choose Copy Select the Receiving cell rightclick on it and choose Paste Special. Then choose Values ==== If that receiving cell is always going to reflect the value in a specific cell (say A1 on Sheet1), you could use a formula: =if(sheet1!a1="","",sheet1!a1) geeeberry wrote: This can't be very hard, but I can't find out the best way to do this, I need to copy the contents of a cell, from one cell, into another cell, in a different sheet on the same workbook. I do not need to copy the formula, what would be the best approach... Its almost like a form fill operation, a label. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I automatically copy cell contents from one cell into
I find that if you name the original cell eg Total (include the worksheet
reference) then all you need t do is goto your new cell and use =SUM(Total), and it will return exactly what is in the original cell -- John "Dave Peterson" wrote: Select the Sending cell Rightclick on it and choose Copy Select the Receiving cell rightclick on it and choose Paste Special. Then choose Values ==== If that receiving cell is always going to reflect the value in a specific cell (say A1 on Sheet1), you could use a formula: =if(sheet1!a1="","",sheet1!a1) geeeberry wrote: This can't be very hard, but I can't find out the best way to do this, I need to copy the contents of a cell, from one cell, into another cell, in a different sheet on the same workbook. I do not need to copy the formula, what would be the best approach... Its almost like a form fill operation, a label. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell function to copy contents of another cell | Excel Worksheet Functions | |||
| Automatically copy selected information from one worksheet to anot | Excel Discussion (Misc queries) | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
Linear Mode
