Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cell info and info in range of cells on new entry
I would like to enter info into exsiting cell and when I hit enter the
existing info would move down one row. B C D E 5 Enter new info her existing info moves down 6 7 Thanks for the help. -- JoAnn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cell info and info in range of cells on new entry
You could use a worksheet_change event macro within your sheet module to do
this when you enter a value into the last column of the existing row. -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... I would like to enter info into exsiting cell and when I hit enter the existing info would move down one row. B C D E 5 Enter new info her existing info moves down 6 7 Thanks for the help. -- JoAnn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cell info and info in range of cells on new entry
Thanks Don,
i am not to macro savy. Could you show me how that would look? -- JoAnn "Don Guillett" wrote: You could use a worksheet_change event macro within your sheet module to do this when you enter a value into the last column of the existing row. -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... I would like to enter info into exsiting cell and when I hit enter the existing info would move down one row. B C D E 5 Enter new info her existing info moves down 6 7 Thanks for the help. -- JoAnn . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cell info and info in range of cells on new entry
Just got a chance to try it now. And it works how you describe but....
Insted of the target col being e what do I change to make it col a? -- JoAnn "Don Guillett" wrote: Right click sheet tabview codeinsert this. Now when you enter something in col e, a row will be inserted. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column < 5 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... Thanks Don, i am not to macro savy. Could you show me how that would look? -- JoAnn "Don Guillett" wrote: You could use a worksheet_change event macro within your sheet module to do this when you enter a value into the last column of the existing row. -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... I would like to enter info into exsiting cell and when I hit enter the existing info would move down one row. B C D E 5 Enter new info her existing info moves down 6 7 Thanks for the help. -- JoAnn . . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move cell info and info in range of cells on new entry
And is it possible to keep the format of the row?
-- JoAnn "abc" wrote: Just got a chance to try it now. And it works how you describe but.... Insted of the target col being e what do I change to make it col a? -- JoAnn "Don Guillett" wrote: Right click sheet tabview codeinsert this. Now when you enter something in col e, a row will be inserted. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column < 5 Then Exit Sub Rows(Target.Row).Insert End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... Thanks Don, i am not to macro savy. Could you show me how that would look? -- JoAnn "Don Guillett" wrote: You could use a worksheet_change event macro within your sheet module to do this when you enter a value into the last column of the existing row. -- Don Guillett Microsoft MVP Excel SalesAid Software "abc" wrote in message ... I would like to enter info into exsiting cell and when I hit enter the existing info would move down one row. B C D E 5 Enter new info her existing info moves down 6 7 Thanks for the help. -- JoAnn . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
Move cell info and info in neighboring cell on new entry | Excel Discussion (Misc queries) | |||
Want to move several cells info to next available row on master sh | Excel Discussion (Misc queries) | |||
Move cell info on new entry | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |