from line to list

[JanTo]

Dear all,

I´m looking for a code that will create from each line a list of actions:

Brand	Chassi	Customer	Model	Delivery date	Info1	Info2	info3
Honda	abcd1234	3040	CR-V	25.05.2015	Not important	Not important	Not important
Citroen	vjgfja2564	2050	Berlingo	30.05.2015	Not important	Not important	Not important
Mazda	asdfasd4564	1250	CX5	28.05.2015	Not important	Not important	Not important
Range-Rover	fasdf132123	6098	Vogue	5.06.2015	Not important	Not important	Not important
Jaguar	ewerq21331	4512	F-Type	8.07.2015	Not important	Not important	Not important

<tbody>
</tbody>

This data is on the sheet1 but these columns are not always in this order (e.g chassi can be in first column and customer can be in last column etc). It starts always from A1 and ends in column BO. Number of lines are always different.


What I need:

On sheet3 should be created:
These empty rows are needed to be filled manually on sheet3. And the tricky part is that these blocks should be positioned in such a way that when I print them each block should be printed on different paper sheet.

Brand Honda CR-V Chassi no abcd1234 Customer 3040 Delivery date 25.05.2015 Empty row1 Empty row2 Empty row3 Empty row4 Empty row5 Empty row6 Empty row7 Brand Citroen Berlingo Chassi no vjgfja2564 Customer 2050 Delivery date 30.05.2015 Empty row1 Empty row2 Empty row3 Empty row4 Empty row5 Empty row6 Empty row7 <colgroup><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>