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

Excel sheet setup, need only 2 columns with auto-tab and return
 

--Select all columns to the right from ColC. Select ColC hit Ctrl+Shift+Right
arrow to select. From menu FormatColumnHide

--Select the sheet tab which you want to work with. Right click the sheet
tab and click on 'View Code'. This will launch VBE. Paste the below code to
the right blank portion. Get back to to workbook and try out.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Range("A" & Target.Row + 1).Activate
Else
Target.Offset(, 1).Activate
End If
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Seaghost" wrote:

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