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
|