moving cells in Excel
 

Hi Guys

Been having trouble with what seemed like a simple macro to write!. I want
to have an excel sheet where if a value is entered in Column H; the next cell
beside it in column I is selected for data entry. If Data is entered in any
cell in I it then moves down a cell and back 1 cell to the next cell in
column H.

e.g. enter data in cell H1 - I1 becomes active cell
Enter data in I1 - H2 becomes active cell
Enter datain H2 - I2 becomes active cell
etc

Your help would be much appreciated!!

moving cells in Excel
 

right click sheet tabview code insert thissave

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 Then Target.Offset(0, 1).Select
If Target.Column = 9 Then Target.Offset(1, -1).Select
End Sub


--
Don Guillett
SalesAid Software

"Axemaneire" wrote in message
...
Hi Guys

Been having trouble with what seemed like a simple macro to write!. I want
to have an excel sheet where if a value is entered in Column H; the next
cell
beside it in column I is selected for data entry. If Data is entered in
any
cell in I it then moves down a cell and back 1 cell to the next cell in
column H.

e.g. enter data in cell H1 - I1 becomes active cell
Enter data in I1 - H2 becomes active cell
Enter datain H2 - I2 becomes active cell
etc

Your help would be much appreciated!!

moving cells in Excel
 

Thats great Don works perfectly!. Thanks a million!!

"Don Guillett" wrote:

right click sheet tabview code insert thissave

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 Then Target.Offset(0, 1).Select
If Target.Column = 9 Then Target.Offset(1, -1).Select
End Sub


--
Don Guillett
SalesAid Software

"Axemaneire" wrote in message
...
Hi Guys

Been having trouble with what seemed like a simple macro to write!. I want
to have an excel sheet where if a value is entered in Column H; the next
cell
beside it in column I is selected for data entry. If Data is entered in
any
cell in I it then moves down a cell and back 1 cell to the next cell in
column H.

e.g. enter data in cell H1 - I1 becomes active cell
Enter data in I1 - H2 becomes active cell
Enter datain H2 - I2 becomes active cell
etc

Your help would be much appreciated!!

moving cells in Excel
 

glad it helped

--
Don Guillett
SalesAid Software

"Axemaneire" wrote in message
...
Thats great Don works perfectly!. Thanks a million!!

"Don Guillett" wrote:

right click sheet tabview code insert thissave

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 8 Then Target.Offset(0, 1).Select
If Target.Column = 9 Then Target.Offset(1, -1).Select
End Sub


--
Don Guillett
SalesAid Software

"Axemaneire" wrote in message
...
Hi Guys

Been having trouble with what seemed like a simple macro to write!. I
want
to have an excel sheet where if a value is entered in Column H; the
next
cell
beside it in column I is selected for data entry. If Data is entered in
any
cell in I it then moves down a cell and back 1 cell to the next cell in
column H.

e.g. enter data in cell H1 - I1 becomes active cell
Enter data in I1 - H2 becomes active cell
Enter datain H2 - I2 becomes active cell
etc

Your help would be much appreciated!!