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
|