Multiple Inventory entries on the same item

Okay so I'm wondering if there is a way for excel to automatically advance to the next column when entering inventory data so if I need to make another entry on the same item I don't have to advance to the next cell myself.  This would be helpful in streamlining inventory and making it foolproof when adding inventory to a specific item (without having to worry about deleting previously entered data).  I'm hoping there is a way to do this so I can take a tablet when completing my inventory and avoid the old clipboard and paper.