Hi, I wonder if anyone can help with this,

I need a formula that will show the date in cell B1 when a barcode number is scanned into A1, this date then needs to stay that date.

So if we scan a barcode today it will show the number of that code in A1 then the date that this was entered will appear in B1 and stay as todays date, tomorrow the action will be carried out again in A2 and tomorrows date will appear in B2. Hope this is an easy one!?

Thinking about it date and time would be helpful!

Many thanks