Home |
Search |
Today's Posts |
#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 |
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 |