| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy automatically | Excel Discussion (Misc queries) | |||
| copy text box input into another text box automatically | Excel Discussion (Misc queries) | |||
| Copy of data automatically | Excel Worksheet Functions | |||
| Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
| How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) | |||
Hybrid Mode
