Auto arrange copied elements from one to another Excel table

[Vladimir Atanasiu]

Hello!

I use an ERP software, including also the stocks management. The stocks database contains a list with the names, prices etc. of all the products, that are booked into accounts, as it’s shown in the Table1 from the attached document. Periodically, they are made inventories in the enterprise’s production areas that contains some elements of the whole database, and are generated reports with the real stocks of those sectors (as in the Table 2) at that moment, to be registered and correct the previous values. My question is how could be copied the elements and values from the Report 1 of Table 2 into the Report 1 of Table 3, so that they may auto arrange according the order of elements from the Table 1.

Thank you in advance.

Vladimir Atanasiu

[José Augusto]

Hi
Use in B28 the following formula

Please Login or Register  to view this content.

drag down and forward.