Data Overview.

[Aberdham]

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)

[TABLE="width: 1316"]
<tbody>[TR]
[TD]Invoice[/TD]
[TD]Invoice Number[/TD]
[TD]Supplier/Debitor[/TD]
[TD]Description[/TD]
[TD]Invoice Date[/TD]
[TD]FX rate[/TD]
[TD]USD Amount[/TD]
[TD]EUR Amount[/TD]
[TD]Change in Inventory[/TD]
[TD]Machinery[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]K8554214[/TD]
[TD]ADA[/TD]
[TD]Deposit SN 844451[/TD]
[TD="align: right"]1-12-2017[/TD]
[TD="align: right"]1,1885[/TD]
[TD] $361.067,54 [/TD]
[TD] 303.801,05 € [/TD]
[TD]- 303.801,05 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]K8554215[/TD]
[TD]ADA[/TD]
[TD]final payment_ESN 848462[/TD]
[TD="align: right"]1-1-2018[/TD]
[TD="align: right"]1,1993[/TD]
[TD] $358.718,75 [/TD]
[TD] 299.106,77 € [/TD]
[TD]- 299.106,77 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]K8554216[/TD]
[TD]APOM[/TD]
[TD]ollmh5859[/TD]
[TD="align: right"]2-2-2018[/TD]
[TD="align: right"]1,2492[/TD]
[TD] $ 2.600,60 [/TD]
[TD] 2.081,82 € [/TD]
[TD]- 2.081,82 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]85426589[/TD]
[TD]APOM[/TD]
[TD]inspection[/TD]
[TD="align: right"]2-2-2018[/TD]
[TD="align: right"]1,2492[/TD]
[TD] $ 3.461,33 [/TD]
[TD] 2.770,84 € [/TD]
[TD]- 2.770,84 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]85426589[/TD]
[TD]UIJ[/TD]
[TD]opmen[/TD]
[TD="align: right"]2-2-2018[/TD]
[TD="align: right"]1,2492[/TD]
[TD] $ 18.988,94 [/TD]
[TD] 15.200,88 € [/TD]
[TD]- 15.200,88 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]92076858[/TD]
[TD]UIJ[/TD]
[TD]ausi0410[/TD]
[TD="align: right"]13-3-2018[/TD]
[TD="align: right"]1,2378[/TD]
[TD] $ 714,00 [/TD]
[TD] 576,83 € [/TD]
[TD]- 576,83 € [/TD]
[TD="align: right"]1[/TD]
[TD]


Sheet 2 (Sales costs)


[TABLE="width: 974"]
<tbody>[TR]
[TD]Type of invoice[/TD]
[TD]Invoice Number[/TD]
[TD]Supplier/Debitor[/TD]
[TD]Description[/TD]
[TD]Invoice Date[/TD]
[TD]FX rate[/TD]
[TD]USD Amount[/TD]
[TD]EUR Amount[/TD]
[TD]Change in Inventory[/TD]
[TD]Machinery[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]R[/TD]
[TD]AR00214522[/TD]
[TD]ADA[/TD]
[TD]AR00251452[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD="align: right"]1,2384[/TD]
[TD] $ 15.222,00 [/TD]
[TD] € 12.291,67 [/TD]
[TD]- 12.291,67 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]




Sheeet 3 (Purchase cost)
[TABLE="width: 1279"]
<tbody>[TR]
[TD]Type of invoice[/TD]
[TD]Invoice Number[/TD]
[TD]Supplier/Debitor[/TD]
[TD]Description[/TD]
[TD]Invoice Date[/TD]
[TD]FX rate[/TD]
[TD]USD Amount[/TD]
[TD]EUR Amount[/TD]
[TD]Change in Inventory[/TD]
[TD]Machinery[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]58485[/TD]
[TD]AAD[/TD]
[TD]AP001523[/TD]
[TD="align: right"]11-4-2018[/TD]
[TD="align: right"]1,2384[/TD]
[TD] $ 15.222,00 [/TD]
[TD] € 12.291,67 [/TD]
[TD] 12.291,67 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]584885[/TD]
[TD]AAR[/TD]
[TD]AP001524[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 1.600,00 [/TD]
[TD] € 1.298,60 [/TD]
[TD] 1.298,60 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]584882[/TD]
[TD]AAE[/TD]
[TD]AP001525[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 500,00 [/TD]
[TD] € 405,81 [/TD]
[TD] 405,81 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]48595[/TD]
[TD]AES[/TD]
[TD]AP001526[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 18.455,00 [/TD]
[TD] € 14.978,49 [/TD]
[TD] 14.978,49 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]485953[/TD]
[TD]AHJ[/TD]
[TD]AP001527[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 16.746,00 [/TD]
[TD] € 13.591,43 [/TD]
[TD] 13.591,43 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]1007019[/TD]
[TD]UIJ[/TD]
[TD]AP001528[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 6.200,00 [/TD]
[TD] € 5.050,51 [/TD]
[TD] 5.050,51 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]1007020[/TD]
[TD]JIMK[/TD]
[TD]AP001529[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $ 35.000,00 [/TD]
[TD] € 28.434,48 [/TD]
[TD] 28.434,48 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]8958952[/TD]
[TD]KYT[/TD]
[TD]AP001530[/TD]
[TD="align: right"]1-4-2018[/TD]
[TD="align: right"]1,2321[/TD]
[TD] $2.000.000,00 [/TD]
[TD] € 1.617.992,07 [/TD]
[TD] 1.617.992,07 € [/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]


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 !







[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]

 

[Robby19]

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?

 

[Aberdham]

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.