| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Data from one cell to another
I have Data in Cell A10 and I want it to automatically go into cell A30.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
In A30 enter:
=A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
I forgot to tell you that A30 has a formula in it. Will it still work if I
just put =A10? "David Billigmeier" wrote: In A30 enter: =A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
You can't both have the cake and eat it! Why would you automatically get the
value of A10 in A30 and what does the formula in A30 do? -- Regards, Peo Sjoblom "dd" wrote in message ... I forgot to tell you that A30 has a formula in it. Will it still work if I just put =A10? "David Billigmeier" wrote: In A30 enter: =A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
Ok. The formula counts the cells above.
"Peo Sjoblom" wrote: You can't both have the cake and eat it! Why would you automatically get the value of A10 in A30 and what does the formula in A30 do? -- Regards, Peo Sjoblom "dd" wrote in message ... I forgot to tell you that A30 has a formula in it. Will it still work if I just put =A10? "David Billigmeier" wrote: In A30 enter: =A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
I'm confused as well. So you want the formula currently in A30 (count of the
cells above) AND the value in A10 to both be displayed in A30? If so, you would have to concatenate the values together some how, like: =CONCATENATE(<formula currently in A30," ",A10) -- Regards, Dave "dd" wrote: Ok. The formula counts the cells above. "Peo Sjoblom" wrote: You can't both have the cake and eat it! Why would you automatically get the value of A10 in A30 and what does the formula in A30 do? -- Regards, Peo Sjoblom "dd" wrote in message ... I forgot to tell you that A30 has a formula in it. Will it still work if I just put =A10? "David Billigmeier" wrote: In A30 enter: =A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Data from one cell to another
What result would you expect to get when you want to count the cells above
and then get A10 You can concatenate like this =Existing formula in A30&" "&A10 replace Existing formula etc ...with whatever you got already which will give you both values as text in the same cell -- Regards, Peo Sjoblom "dd" wrote in message ... Ok. The formula counts the cells above. "Peo Sjoblom" wrote: You can't both have the cake and eat it! Why would you automatically get the value of A10 in A30 and what does the formula in A30 do? -- Regards, Peo Sjoblom "dd" wrote in message ... I forgot to tell you that A30 has a formula in it. Will it still work if I just put =A10? "David Billigmeier" wrote: In A30 enter: =A10 -- Regards, Dave "dd" wrote: I have Data in Cell A10 and I want it to automatically go into cell A30. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| How do I copy data from one cell to the next occurrence of data? | Excel Worksheet Functions | |||
| Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
Linear Mode
