How do I set a rule for moving one cell down + one left in Exc
Thank you very much Stefi
The sub did the trick! I'll get going on implementing this on the sheet
I'm using on the pocket excel to see if it'll run there too. This will save
us alot of trouble should it all work as intended.
Thanks again ;)
Neuroner
"Stefi" wrote:
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
|