Excel for accounting: 1 row of information, multiple rows of booking, copy down

[Alex_Excel]

Hello,

say I have multiple invoices that are all made the same way. Different VAT tax codes are invoiced. Total invoice = amount without tax + tax. These different VAT codes go into different rows in a second tab that specifies the tax code.

For example:

Site ID	Document Date	Doc. Nr	Amount 0%	Amount 6%	Amount 12%	Amount 21%	Amount 21% N-Food	Total	Costcenter
484	14032015	1817/290453	50,00	435,41	100,00	121,00	75,00	781,41	3B2S000484

<tbody>
</tbody>

Should give me the following:

Posting date	Document date	Doc Type	Pk	Account number	Amount	Tax code	Cost Center
24032015	14032015	KR	31	246851	781,41	**
24032015	14032015	KR	40	60711000	50,00	z0	3B2S000484
24032015	14032015	KR	40	60711000	435,41	v1	3B2S000484
24032015	14032015	KR	40	60711000	100,00	v2	3B2S000484
24032015	14032015	KR	40	60711000	121,00	v3	3B2S000484
24032015	14032015	KR	40	60690000	75,00	v3	3B2S000484

<tbody>
</tbody>

Is there any way of referencing this so that when I add another row of information about the invoice, automatically 6 rows extra are created that refer to 1 new row ?

Thanks in advance,

Alex_Excel