Hi,

Thanks for responding, what I would like to do is to insert a manual page break at each cost centre point, for which there are pages and pages of data. I could find this for pivot tables or to insert hbreaks etc but not just to say "at each cost centre insert a page break".

I would also like to insert subtotals at each cost centre using VBA rather than excel itself. I'm still learning so any help would...

Cost Centre Ann Budget WTE Budget WTE Actual Apr May Jun
A58000 0 0.00 0.00 1,929.84 1,929.84 1,929.84
23,000 0.00 0.00 0.00 0.00 0.00
-219,232 0.00 0.00 0.00 0.00 0.00
0 0.00 1.00 6,575.87 6,575.87 6,575.87
78,888 1.00 0.00 0.00 0.00 0.00
0 0.00 0.00 2,324.40 2,324.40 2,324.40
27,881 0.50 0.00 0.00 0.00 0.00
0 0.00 1.00 0.00 0.00 0.00
0 0.00 1.00 3,222.21 3,219.55 3,219.55...