I am seeking some assistance from you intelligent people out there. I am working on creating a data entry system that will capture general customer data and then scanned data. I am capturing customer general information on one worksheet and the scanned data (serial numbers) on another worksheet with the customer data and execution dates (At this point Customer Name is primary key). With that in mind, I am trying to figure out how to setup the form designed for the Serial Number scan (capture) to allow multiple entries in Visual Basic.
Flow of forms 'Customer Setup' -> 'Project Information' -> 'Serial Number Entry'. Project Information and Serial Number Entry are going to populate the same worksheet. I will need the information from Project Information form to copy for each Serial Number scanned. So how I do I program the Serial Number entry form to allow multiple scans (Scanning appears to work just like keying in numbers and hitting enter key) and populate individual cells/row?
Flow of forms 'Customer Setup' -> 'Project Information' -> 'Serial Number Entry'. Project Information and Serial Number Entry are going to populate the same worksheet. I will need the information from Project Information form to copy for each Serial Number scanned. So how I do I program the Serial Number entry form to allow multiple scans (Scanning appears to work just like keying in numbers and hitting enter key) and populate individual cells/row?