|
How do I set a rule for moving one cell down + one left in Excel?
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 |
How do I set a rule for moving one cell down + one left in Excel?
A tiny trick:
1. type something in A1 2. touch TAB to move to B1 3. type in B1 4. touch ENTER You will snap down to A2 for the next entry!! -- Gary''s Student - gsnu200908 "Neuroner" wrote: 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 |
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 |
How do I set a rule for moving one cell down + one left in Excel?
I had forgotten that one! Thanks for the reminder
best wishes -- Bernard "Gary''s Student" wrote in message ... A tiny trick: 1. type something in A1 2. touch TAB to move to B1 3. type in B1 4. touch ENTER You will snap down to A2 for the next entry!! -- Gary''s Student - gsnu200908 "Neuroner" wrote: 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 |
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 |
| All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com