Nov 18 2022 05:43 AM
I have to different inventory systems... which they have only common factor is the barcode while issuing.
But, they are different in stock codes, so I need to match the barcode and results the common products descriptions
Nov 18 2022 08:33 AM
A possible solution could be Power Query. The blue dynamic tables represent your different inventory systems. The only link between these is the Barcode column. You can enter data into the blue dynamic tables. Then click in any cell of the green table and right-click with the mouse. Then select refresh and the green table displays the result.
Nov 18 2022 10:04 AM
Thank you very much for this quick response. I am going to try it out and give back the feedback.
Thank you.