Inventory counting sheet and produce a packing list using barcode scanner.

Hello everyone,

so I have the attached packing/Counting list
I use a barcode scanner to count the products (one by one) and have the information of them on the sheet named "assortment" as shown. I do this manually, unfortunately!
is there any chance to have the "assortment" sheet automated by formulas? only with scanning the barcodes at sheet named "Reader" in columns "Item Barcode READER" and "Box Barcode READER"? and the others will be automatically read?

I'd really appreciate it if you can help me with this and teach me how to do it

Thanks in advance.

Cheers.

First, Thank you very much for your kind help; second, maybe I didn't explain well how to work with the sheet, the matter is that I need only to read the barcode of the product at "item barcode READER" and get its description at "Full Des1" based on the whole barcode sheet "BDTK_BAR", and count it as +1, if the barcode changed at "item barcode READER" the "Full Des2" will be filled according to the new barcode value.
the form which I have made is free-to edit. it doesn't matter what columns or rows you add or delete, please feel free to edit them, the important one here is the "assortment" sheet which I have to upload it to my system. also the box number doesn't exceed 400 so any need to work on 1000 rows or more.

The main idea here is that I need to count the products while packing them by reading their barcodes with a barcode reader tool and have the Packing List of them as the Assortment sheet shows.

I really appreciate your help. Thanks again.

Mark00963. actually it is very complex issue. For me it is not clear how you scan barcode and how looks like a process. I ansvered only for

is there any chance to have the "assortment" sheet automated by formulas?