count barcode scanner entries

[adquinn]

I have a simple spreadsheet. I use the Wasp 3900 to scan a barcode into Excel- The number is static and it is 1. I want to be able in the column next to it have it add up each time I scan into the previous cell.

 

[diddi]

hi and welcome to the board

i think i would use a userform to capture the barcodes and keep a tally on your sheet (or userform)

 

[adquinn]

Thanks. I am not skilled in VB, but it is a simple spreadsheet with ID, First Name, Last Name, Visits, Total Visits. When I use the barcode scanner it enters 1 into the Visit column and then goes down to the next cell. If I use the scanner again in the same cell, then it enters a 1. I would like it to add to this number in the next column under Total Visits. I can paste a code into VB, but I really do not know how to write code. Any help would be appreciated.