View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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