Copy Data from one cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Data in Cell A10 and I want it to automatically go into cell A30.
 
I forgot to tell you that A30 has a formula in it. Will it still work if I
just put =A10?
 
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?
 
Ok. The formula counts the cells above.

Peo Sjoblom said:
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?
Click to expand...
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying cells from one sheet to another 5
Data lookup 2
>4.5 3
Convert Text to Formula 4
How to appy the formular with different cell parameters~kindly hel 2
sum character 6
How can I make a cell = another cell based on a condition? 13
Questions about copying a Formula 9

Back
Top