Data Overview.

Aberdham

Board Regular
Joined
Mar 8, 2018
Messages
140
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)

InvoiceInvoice NumberSupplier/DebitorDescriptionInvoice DateFX rateUSD AmountEUR AmountChange in InventoryMachineryCategory
AK8554214ADADeposit SN 8444511-12-20171,1885 $361.067,54 303.801,05 € - 303.801,05 € 1
AK8554215ADAfinal payment_ESN 8484621-1-20181,1993 $358.718,75 299.106,77 € - 299.106,77 € 1
AK8554216APOMollmh58592-2-20181,2492 $ 2.600,60 2.081,82 € - 2.081,82 € 1
A85426589APOMinspection2-2-20181,2492 $ 3.461,33 2.770,84 € - 2.770,84 € 1
A85426589UIJopmen2-2-20181,2492 $ 18.988,94 15.200,88 € - 15.200,88 € 1
A92076858UIJausi041013-3-20181,2378 $ 714,00 576,83 € - 576,83 € 1


Sheet 2 (Sales costs)


Type of invoiceInvoice NumberSupplier/DebitorDescriptionInvoice DateFX rateUSD AmountEUR AmountChange in InventoryMachineryCategory
RAR00214522ADAAR0025145211-4-20181,2384 $ 15.222,00 € 12.291,67 - 12.291,67 € 1

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>




Sheeet 3 (Purchase cost)
Type of invoiceInvoice NumberSupplier/DebitorDescriptionInvoice DateFX rateUSD AmountEUR AmountChange in InventoryMachineryCategory
P58485AADAP00152311-4-20181,2384 $ 15.222,00 € 12.291,67 12.291,67 € 1
P584885AARAP0015241-4-20181,2321 $ 1.600,00 € 1.298,60 1.298,60 € 1
P584882AAEAP0015251-4-20181,2321 $ 500,00 € 405,81 405,81 € 1
P48595AESAP0015261-4-20181,2321 $ 18.455,00 € 14.978,49 14.978,49 € 1
P485953AHJAP0015271-4-20181,2321 $ 16.746,00 € 13.591,43 13.591,43 € 1
P1007019UIJAP0015281-4-20181,2321 $ 6.200,00 € 5.050,51 5.050,51 € 1
P1007020JIMKAP0015291-4-20181,2321 $ 35.000,00 € 28.434,48 28.434,48 € 1
P8958952KYTAP0015301-4-20181,2321 $2.000.000,00 € 1.617.992,07 1.617.992,07 € 1

<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>
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Robby19

Board Regular
Joined
Mar 19, 2018
Messages
227
What do you mean by "transfer to another sheet"? You mean you want all of the data on one sheet? Or you want to be able to pull specific data regarding a selected machine, for example show the historical, sales, and purchase costs of a machine on one sheet?
 
Last edited:

Aberdham

Board Regular
Joined
Mar 8, 2018
Messages
140
What do you mean by "transfer to another sheet"? You mean you want all of the data on one sheet? Or you want to be able to pull specific data regarding a selected machine, for example show the historical, sales, and purchase costs of a machine on one sheet?
Thanks for replying.

I mean to pull specific data based on the machine number.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,823
Messages
5,544,534
Members
410,618
Latest member
bigz
Top