How do I set a rule for moving one cell down + one left in Excel?

N

Neuroner

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
 
G

Gary''s Student

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!!
 
S

Stefi

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:
 
N

Neuroner

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
 
S

Stefi

Yes, it's possible, I don't know Pocket Excel, sorry!
--
Regards!
Stefi



„teylyn†ezt írta:
I don't think that you can achieve that kind of functionality with
Pocket Excel. It'll be hard enough with Excel for Windows, requiring
VBA, but that won't run on Pocket XL, AFAIK

cheers

Teylyn

Neuroner;549137 said:
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


--
teylyn
------------------------------------------------------------------------
teylyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=983
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=151258

Microsoft Office Help

.
 
Joined
Jun 3, 2014
Messages
3
Reaction score
0
I am testing about the related projects these days. Do you have any ideas about it? Or any good suggestion? Thanks in advance.



Best regards,
Arron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top