Basically i want to have the date & time populate a cell automatically when
another cell has a barcode scanned into it, that is no problem but when the
time passes to another minute and another barcode is entered it changes every
date & time in the sheet! i want them to stay static once they are in the
sheet.

Can anyone help???