hi, i have a question, i’ve created a sheet with my inventory all product have a unique EAN code, i have created a new sheet “inventory update” beacuse periodicly i want check the quantity of the inventary.
and i want this:
EAN CODE 00001 quantity 1
EAN CODE 00002 quantity 2
EAN CODE 00003 quantity 2
EAN CODE 00001 quantity 1 (i want sum this quantity at the first line because EAN is existing and not show this)
is possible? thanks