Hi Excel pros,
I have got a question that i would like to ask: recently I have received an Excel file with all the sales cost, purchase cost and historical cost with respective to 120 machinery. and I have managed to split all the historal data, sales cost and purchase cost within 3 Tabs in 1 workbook, and I would like to have them all Transfer to another sheet named overview Machinery 1:
Here are sheet 1 Looks like: (Historical)
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>
I have got a question that i would like to ask: recently I have received an Excel file with all the sales cost, purchase cost and historical cost with respective to 120 machinery. and I have managed to split all the historal data, sales cost and purchase cost within 3 Tabs in 1 workbook, and I would like to have them all Transfer to another sheet named overview Machinery 1:
Here are sheet 1 Looks like: (Historical)
Invoice | Invoice Number | Supplier/Debitor | Description | Invoice Date | FX rate | USD Amount | EUR Amount | Change in Inventory | Machinery | Category | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | K8554214 | ADA | Deposit SN 844451 | 1-12-2017 | 1,1885 | $361.067,54 | 303.801,05 € | - 303.801,05 € | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | K8554215 | ADA | final payment_ESN 848462 | 1-1-2018 | 1,1993 | $358.718,75 | 299.106,77 € | - 299.106,77 € | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | K8554216 | APOM | ollmh5859 | 2-2-2018 | 1,2492 | $ 2.600,60 | 2.081,82 € | - 2.081,82 € | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | 85426589 | APOM | inspection | 2-2-2018 | 1,2492 | $ 3.461,33 | 2.770,84 € | - 2.770,84 € | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | 85426589 | UIJ | opmen | 2-2-2018 | 1,2492 | $ 18.988,94 | 15.200,88 € | - 15.200,88 € | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
A | 92076858 | UIJ | ausi0410 | 13-3-2018 | 1,2378 | $ 714,00 | 576,83 € | - 576,83 € | 1 | Sheet 2 (Sales costs)
<tbody> </tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup> Sheeet 3 (Purchase cost)
<tbody> </tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup> I would like to have them Transfer to the a new sheet within the same workbook named overview machinery 1 Please assist me with this Tasks. It would be much appreciated !! Thank you very much in advance ! |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>