View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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