Hi there,

I can create a barcode in Excel to complete data in one cell, but what I want to be able to do is scan one barcode and fill two pieces of data into two cells.

See example below. Is it possible to have the type and the current date encoded into one barcode that will enter data into both Cell B2 and C3.

ID Type Date
1 A 27/04/2021
2 B 28/04/2021
3
4
5

To have the date encoded into a barcode - can I use the formula =TODAY() or is there a better way?

Thanks,
Orlaith