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
|