| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copy one cell to another
How can i get a cell to input the same information i type in one including
text, for example: cell 1 F3: John Doe 23023 and i want the same information that i display to show up on another cell f20: John doe 23023 Help please thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy one cell to another
In F20 write this simple formula:
=F3. "gus" wrote: How can i get a cell to input the same information i type in one including text, for example: cell 1 F3: John Doe 23023 and i want the same information that i display to show up on another cell f20: John doe 23023 Help please thank you |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy one cell to another
In F20 write this simple formula:
=F3 Suggest a small tweak, in F20: =IF(F3="","",F3) -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy one cell to another
Thanks the =f3 work fine thank you very much :)
"FC" wrote: In F20 write this simple formula: =F3. "gus" wrote: How can i get a cell to input the same information i type in one including text, for example: cell 1 F3: John Doe 23023 and i want the same information that i display to show up on another cell f20: John doe 23023 Help please thank you |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy one cell to another
thanks it work fine, perfect thanks a lot
"FC" wrote: In F20 write this simple formula: =F3. "gus" wrote: How can i get a cell to input the same information i type in one including text, for example: cell 1 F3: John Doe 23023 and i want the same information that i display to show up on another cell f20: John doe 23023 Help please thank you |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copy one cell to another
Without formulas to copy the entry 17 rows down.
Right click sheet tabview codeinsert this If you only want one use the formula suggested. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("f2:f222")) Is Nothing Then Exit Sub Application.EnableEvents = False Target.Offset(17) = Target Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "gus" wrote in message ... How can i get a cell to input the same information i type in one including text, for example: cell 1 F3: John Doe 23023 and i want the same information that i display to show up on another cell f20: John doe 23023 Help please thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
