General discussion
July 21, 2003 at 11:50 AM
gniazdo

how to Auto Advance cells in Excel

by gniazdo . Updated 23 years, 2 months ago

I have a real simple spread sheet that I am using to keep track of serial numbers and Property ID Numbers on computers. The thing is I am using a Barcode Scanner hooked up to a laptop to enter the numbers. What I am looking for is a way to advance to the next cell in a row automaticly after X amount of characters have be entered into the previous cell. This way i would be able to just continue scanning bar codes without having to go back to the keyboard and hit the tab key or the downarrow thenhome key to start a new row. I tried messing around with macros but I do not know enough about them.
Thanks

This discussion is locked

All Comments