consolidate data on one criteria and copy to other sheet

[ellilio]

hi, after a long time of searching I decided to post my question and ask for help.

I have a data like this from sales, and I should send it to invoice template for print. I want to create a macro
asking for invoice number to print. then send data to a template invoice on a sheet 2

Inv#		Date		Desc	Qty	Length	Width	Thickness		CubicM
13		10/24/2017		Oak2	1	230	15	5		0.01725
13		10/24/2017		Oak2	1	250	17	5		0.02125
13		10/24/2017		Oak2	1	260	18	5		0.02340
13		10/24/2017		Oak2	1	300	19	5		0.02850
13		10/24/2017		Pine	5	300	15	5		0.11250
13		10/24/2017		Pine	4	300	13	5		0.07800
14		10/27/2017		Oak1	1	245	15	5		0.0184
14		10/27/2017		Oak1	1	245	15	5		0.0184
14		10/27/2017		Oak2	1	250	16	5		0.0200
14		10/27/2017		Oak3	1	260	17	5		0.0221
14		10/27/2017		Oak2	1	280	18	5		0.0252
14		10/27/2017		Oak3	1	255	19	5		0.0242
14		10/27/2017		Pine	5	300	15	5		0.1125

<colgroup><col><col><col span="4"><col><col></colgroup><tbody>
</tbody>

on sheet 2 invoice template it should look like this

invoice number 13


14 A B C
15 0.0904 4 Oak2
16 0.1905 9 pine


Thanks in advance
ellilio