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

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

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

.

Move cell info and info in range of cells on new entry
 

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

.

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

.


.

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

.


.