View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seaghost Seaghost is offline
external usenet poster
 
Posts: 1
Default Excel sheet setup, need only 2 columns with auto-tab and return

Hello all, I was wondering if anyone can help me with a slight issue, I'm
unsure whether Excel has this functionality.

What I need is a spreadsheet using only 2 columns with the first column auto
advancing to the next column then after data is entered in the 2nd I need it
to auto return to the next row first column.

Now here's the stickler, I am using a Symbol Tech hand scanner connected to
a thinkpad while doing inventory of our IT department. Each piece of
equipment has a S/N and asset tag which I need to scan thus the need for only
2 columns. And due to the fact that while using the scanner I am sometimes
10 or 20ft away from the thinkpad it is a real pain to have to walk over
after each scan or to move the equipment off of the rack.

So if anyone has any ideas I'm willing to listen :) If excel cannot do this
then it's all ok, just means I will have to get a commercial software package
somewhere that can do this. TIA