Spreasheet is vulnerable to operator error

[GeorgeTriton]

I am trying to create an inventory adjustment sheet whereby the operator enters the Item number and automatically they are brought to the Item Line, where I want them to make the necessary inventory adjustments to Qty and Location as required. I am worried that by them manually doing this there is a risk of accidentally going to the wrong Location or entering the wrong Qty. Any suggestions would be greatly appreciated.

[Simon Lloyd]

Hi, i haven't looked at your sheet but the code below works like this: if you enter a value in to A2 and hit enter the cursor moves to an empty cell below and then you are transported to the cell that contains the same text as A2. It needs to be put in the worksheet module you are working with.

Please Login or Register  to view this content.

[GeorgeTriton]

This is close to what I have, however I do have multiple parts in the same location and by using the Sub you suggested the Item # goes to the 1st location identified. I need to link Item # and Location together

[Simon Lloyd]

Thats because i based my sub on this!

operator enters the Item number and automatically they are brought to the Item Line, where I want them to make the necessary inventory adjustments

you didnt give all te information needed to give you the solution you wanted!