Discussion Locked

how to Auto Advance cells in Excel

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by dklippert

Sorry, but all macros are on hold while a cell is being edited.
You could select all of the cells that will be receiving data, so you will only have to use the tab key.
You could also go to Tools>Options Edit and change the direction for the Enter key, which might be easier to hit.

by gniazdo

Yeah that was a good idea but about changing the function of enter which is automatically entered each time the bar code scanner scans a code but I need to Scan a product ID then go across 1 cell. Scan a Property Tag then go to the beginning of the next row and repeat the process.

by gniazdo

Thanks for the link but all of that stuff is way over my head. I have programmed before but not macros in Office.I was kind of wondering if there was a way to Have only 2 colums in the spread sheet then if it would advance the way I need it to automatically?

by pierrejamme

Review your Bar Coder manual, it should tell you how to do this by settings on your scanner. Bar Code Scanners are independant of software, that is they can scan into notepad if you wish.

by gniazdo

this is true but I could choose enter to be hit after scanning a code or for tab to be hit. What I need is Scan,tab, scann,Enter,scan,home,Repeat which I can't program into the scanner.

This discussion is closed to new replies.