Copy Data from one cell to another
 

I have Data in Cell A10 and I want it to automatically go into cell A30.

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.

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.

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.

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.

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.

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.