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)

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) Type of invoice Invoice Number Supplier/Debitor Description Invoice Date FX rate USD Amount EUR Amount Change in Inventory Machinery Category R AR00214522 ADA AR00251452 11-4-2018 1,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 invoice Invoice Number Supplier/Debitor Description Invoice Date FX rate USD Amount EUR Amount Change in Inventory Machinery Category P 58485 AAD AP001523 11-4-2018 1,2384 $ 15.222,00 € 12.291,67 12.291,67 € 1 P 584885 AAR AP001524 1-4-2018 1,2321 $ 1.600,00 € 1.298,60 1.298,60 € 1 P 584882 AAE AP001525 1-4-2018 1,2321 $ 500,00 € 405,81 405,81 € 1 P 48595 AES AP001526 1-4-2018 1,2321 $ 18.455,00 € 14.978,49 14.978,49 € 1 P 485953 AHJ AP001527 1-4-2018 1,2321 $ 16.746,00 € 13.591,43 13.591,43 € 1 P 1007019 UIJ AP001528 1-4-2018 1,2321 $ 6.200,00 € 5.050,51 5.050,51 € 1 P 1007020 JIMK AP001529 1-4-2018 1,2321 $ 35.000,00 € 28.434,48 28.434,48 € 1 P 8958952 KYT AP001530 1-4-2018 1,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>

 

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