The Problem:
I process several parts a day (up to hundreds) that each have their an individual unique serial number (sequential).
The Process:
When I begin processing, a new worksheet is created and I input the serial number into the worksheet (we'll say cell A1 for sake of argument). Serial numbers can be compose of up to 7 Alphanumeric and/or numeric characters. Once the data is entered, I click another button to continue processing. The workbook is saved under a new name, and the process is reset to the beginning using the original workbook (which does not have a the worksheet created yet).
The idea:
I would like to set this up so that after the worksheet is created, all I have to do is enter a minimum amount of information in cell A1 (such as the last two digits), and when I hit enter, the cell (A1) will automatically have the complete serial number information, and will begin the next step of processing (so that I don't need to hit another button).
Is this possible, or am I am just another raving lunatic looking for an easy way out?
Example set of Serial Numbers: XX00001 - XX00201
When processing these 200 parts, I would love to be able to only have to type in the final 2 or 3 digits, and processing would continue automatically.
I process several parts a day (up to hundreds) that each have their an individual unique serial number (sequential).
The Process:
When I begin processing, a new worksheet is created and I input the serial number into the worksheet (we'll say cell A1 for sake of argument). Serial numbers can be compose of up to 7 Alphanumeric and/or numeric characters. Once the data is entered, I click another button to continue processing. The workbook is saved under a new name, and the process is reset to the beginning using the original workbook (which does not have a the worksheet created yet).
The idea:
I would like to set this up so that after the worksheet is created, all I have to do is enter a minimum amount of information in cell A1 (such as the last two digits), and when I hit enter, the cell (A1) will automatically have the complete serial number information, and will begin the next step of processing (so that I don't need to hit another button).
Is this possible, or am I am just another raving lunatic looking for an easy way out?
Example set of Serial Numbers: XX00001 - XX00201
When processing these 200 parts, I would love to be able to only have to type in the final 2 or 3 digits, and processing would continue automatically.