automatically copy text

[dbconn]

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

 

[Jacob Skaria]

Do you mean

Sub Macro()
Range("D110").NumberFormat = "0000"
End Sub

 

[Jacob Skaria]

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.

 

[trip_to_tokyo]

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]

Thanks so much
--
dbconn

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.