Hi - I am looking to create a record log in Excel 07 by scanning in various barcodes with one of the scans triggering an auto entry of current date in column A and a constant data in column F. Seven columns total with indefinite amount of rows.
My current setup: I can scan six columns with barcodes and have to manually enter current date (A column), then tab over to column B and continue scanning the remaining columns. I "unlocked" (Format/Protection) the seven (A-G) columns and protected the sheet. This allows me to return to the first (A) column after my last scan. Column six (F) is a constant entry was also wondering if this can also be automatically entered. I do not want any future scans to overwrite any previous data as some items may eventually return again.
My desired outcome: When I scan in column B (persons name) I would like for the current date to auto enter in column A and a fixed entry "4500 PSI" auto enter in column F. Then I would continue with the remaining scans. Challenge will be to not overwrite Column F. If this can't be done that I am open to moving Column F into column B and sliding remaining columns over. Any ideas and suggestions are appreciated. Thanks!
Sample:
<tbody>
</tbody>
My current setup: I can scan six columns with barcodes and have to manually enter current date (A column), then tab over to column B and continue scanning the remaining columns. I "unlocked" (Format/Protection) the seven (A-G) columns and protected the sheet. This allows me to return to the first (A) column after my last scan. Column six (F) is a constant entry was also wondering if this can also be automatically entered. I do not want any future scans to overwrite any previous data as some items may eventually return again.
My desired outcome: When I scan in column B (persons name) I would like for the current date to auto enter in column A and a fixed entry "4500 PSI" auto enter in column F. Then I would continue with the remaining scans. Challenge will be to not overwrite Column F. If this can't be done that I am open to moving Column F into column B and sliding remaining columns over. Any ideas and suggestions are appreciated. Thanks!
Sample:
Date | Name of Person Filling | Cylinder Serial Number | Manufacture Date | Hydrostatic Test Date | Final Cylinder PSI | Breathing Air Source |
10/29/2014 | Greg Doe | ALT- 245098 | 0406 | 0406 | 4500 PSI | Unit 25 |
10/29/2014 | Greg Doe | OK 169824 | 0406 | 0711 | 4500 PSI | Unit 25 |
10/30/2014 | John Sammy | 4500 PSI |
<tbody>
</tbody>