Dynamically Scaling pages based on page breaks

[Kalvas]

Is there anyway I can make excel scale a set amount of information between page breaks fit 1 page wide 1 page tall? using a macro.

[TABLE="width: 1291"]
<tbody>[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Llandeilo[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.1725[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Ammanford[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.0515[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Home centre[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Ystradgynlais[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5567[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Carmarthen[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5117[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Llanelli[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5994[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Port Talbot[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.0001[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Pembroke Dock[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5714[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Swansea[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.0231[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Cardigan[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.0011[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Neath[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.5262[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Caseys Roofing[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Maesteg[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.2162[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Total Plumbing Port Talbot[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]FT000010[/TD]
[TD]SPAX SCREWS 1000pc TRADE PACK [/TD]
[TD]Total Plumbing Pembroke Dock[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]FT000010 Total[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.2299[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]107[/TD]
[/TR]
</tbody>[/TABLE]

I essentially have this data repeated multiple times depending on how many products I am looking at, I would like this repeated 3 times per page, which is where the page breaks are currently being placed. When i tried to set Width 1 page the automatic page breaks would only allow two of these per page at 100% scaling.

any help you could give me with this would be greatly appreciated.

 

[Kalvas]

Oh and if its entirely possible to scale the length of the cells to use the full width.