Hi,
I am working on a spreadsheet utilizing a barcode scanner. Barcodes are scanned into Column A and when they are done being scanned I have a macro to fill in Column B with the scanner's initials and Column C with the date of the scan. I am running into issues if the scans are performed by a different person my current macro starts back over at B2:B & LastRowColumnA. I cannot figure out how to start the fill down starting at the last row in column B.
I have tried to inserting Dim LastRowColumnB As Long and trying to fit in LastRowColumnB:B and this is not the correct code. I will use whatever the appropriate method is to do the same fill with Column C. Any help would be greatly appreciated.
I am working on a spreadsheet utilizing a barcode scanner. Barcodes are scanned into Column A and when they are done being scanned I have a macro to fill in Column B with the scanner's initials and Column C with the date of the scan. I am running into issues if the scans are performed by a different person my current macro starts back over at B2:B & LastRowColumnA. I cannot figure out how to start the fill down starting at the last row in column B.
I have tried to inserting Dim LastRowColumnB As Long and trying to fit in LastRowColumnB:B and this is not the correct code. I will use whatever the appropriate method is to do the same fill with Column C. Any help would be greatly appreciated.