How do I set a rule for moving one cell down + one left in Excel?
You have to install this change event sub for that:
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row + Target.Column - 1, 3 - Target.Column).Select
End Sub
Post if you need help to install it!
Regards,
Stefi
€˛Neuroner€¯ ezt Ć*rta:
The time for recounting the storage in my office!
About 1300 different products with barcodes. I want to use a mobile device
with pocket EXcel, and need the A coloumn to jump one cell to the right once
it has a value. In coloum B i want to input the number of products in stock.
Once I key in an integer there, I want the excel sheet to jump once cell down
and once cell left, in order to be in coloum A - ready for me to scan the next
barcode.
How do I set this up?
Appretiate the help
|