Insert Row and Non-contiguous Print Area Macro

Hi All,

I'm actually an idiot about VBA . Could you help me on my problem?

I have a document which user are allow key-in 2 products only and does not allow me to insert rows. Therefore, whenever I would like to add Product, I have to copy the entire page and paste in a new sheet in order for me to enter the 3rd and 4th product.

Is it possible to use macro to create "INSERT ROW" (repeat row20 to row26) to allow user key in the 3rd product and when print out it must be 2 grades in 1 sheet. Which mean its repeat the header row 1 to row 17 and repeat the footer row 27 to row 43. Therefore, if I have 3 products, it will print out in 2 pages which is 1st page 2 product, 2nd page 1 product with 1 empty product.

Thanks for any help.

Regards.