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

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

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
---

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

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

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