automatically copy text
 

This forum has been a great help. Now I need a formula that will
automatically copy text from one cell to another when I change the text in
the first cell.

Much appreciated
--
dbconn

automatically copy text
 

Do you mean

Sub Macro()
Range("D1:D10").NumberFormat = "0000"
End Sub

--
Jacob


"dbconn" wrote:

This forum has been a great help. Now I need a formula that will
automatically copy text from one cell to another when I change the text in
the first cell.

Much appreciated
--
dbconn

automatically copy text
 

Please ignore the previous post...

Formulas cannot transfer data. It can only refer to another cell. You will
have to use a VBA solution to accomplish data transfer.

--
Jacob


"Jacob Skaria" wrote:

Do you mean

Sub Macro()
Range("D1:D10").NumberFormat = "0000"
End Sub

--
Jacob


"dbconn" wrote:

This forum has been a great help. Now I need a formula that will
automatically copy text from one cell to another when I change the text in
the first cell.

Much appreciated
--
dbconn

automatically copy text
 

In EXCEL 2007:-

In cell A 1 type:-

text

In cell A type:-

=A1

Both cells will now have the word:-

text

- in them.

If my comments have helped please hit Yes.

Thanks.

"dbconn" wrote:

This forum has been a great help. Now I need a formula that will
automatically copy text from one cell to another when I change the text in
the first cell.

Much appreciated
--
dbconn

automatically copy text
 

Thanks so much
--
dbconn


"trip_to_tokyo" wrote:

In EXCEL 2007:-

In cell A 1 type:-

text

In cell A type:-

=A1

Both cells will now have the word:-

text

- in them.

If my comments have helped please hit Yes.

Thanks.

"dbconn" wrote:

This forum has been a great help. Now I need a formula that will
automatically copy text from one cell to another when I change the text in
the first cell.

Much appreciated
--
dbconn