Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setup help/excel wk/sheet to record museum library collection | New Users to Excel | |||
how to setup a excel sheet to be protect after save and close file | Excel Discussion (Misc queries) | |||
Order Sheet Excel Setup | New Users to Excel | |||
How do I setup in Excel an 11 X 17 work sheet? | Excel Discussion (Misc queries) | |||
how can you auto return from columns B1 to A2 | Excel Discussion (Misc queries) |