enter six numbers, automatically go to next cell

[amerifax]

I'm trying to use Excel 2013 to automatically enter data. I have four cells, three of which always have the same format.
A1 - 6c (Seal)
B1 - dated (PerDate)
C1 - 5c (SC)
D1 - 7c (Insp)

A1 always has six numbers, alpha characters would be incorrect. it is always six numbers and after six numbers should advance to the next cell, B1
B1 always a date format. After data center issued automatically advance C1.
C1 is always five numbers and with thefifth number added it should advance to D1 automatically.
D1 the value can be anywhere from 3 to 7 numbers. Whatever the value of the number it should be preceded by zeros.
Example: 242 would equal 0000242.,

After a value is entered into D1 the cursor should drop down one line and be in the A2 position. Not sure what would be the best way to handle this. But I would the entering a couple hundred records at a time.
All values would be numbers in the text fields so how full characters would be an error.

Back in a day I use a product called Quattro Pro using macros very extensively. I have failed to stay on top of macros inside of Excel. But I surely wouldn't like to start using them.

Bob

 

[Stan_C]

You could create a user form that inputs your data line by line. It would work pretty quickly or as fast as you can type

Create an Excel UserForm

 

[nuked]

This would be overwhelmingly difficult to achieve in a spreadsheet as you would have to use a number of keyboard hooks to treat each key press as an event whilst editing a single cell.

 

[amerifax]

This would be overwhelmingly difficult to achieve in a spreadsheet as you would have to use a number of keyboard hooks to treat each key press as an event whilst editing a single cell.

At least now I know it would be a waste of my time. Thank you for your response.

On second thought.
What I'm trying to do is use Dragon to speak the numbers necessary. My thought was if I'm entering six numbers that Excel somehow would know that it's fall and go to the next field. it seems like such a natural I was hoping that Excel had some function built in.
Bob

 

[amerifax]

At least now I know it would be a waste of my time. Thank you for your response.
Bob

I'm checking Access to see if there's any hope with a database.
Bob

 

[amerifax]

Sorry, I forgot to thank you for the help. I have decided to try something in Access that shows a bit of promise.
Bob