how do I insert a page break at each cost centre and a subtotal using VB

[VBhelpalwayswanted]

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
38,679 1.00 0.00 0.00 0.00 0.00
54,740 1.00 0.00 0.00 0.00 0.00
0 0.00 0.00 0.00 0.00 0.00
A58100 0 0.00 0.00 0.00 6,032.24 3,016.12
0 0.00 0.00 1,027.25 -1,027.25 0.00
0 0.00 0.00 6,402.94 6,401.29 6,401.29
0 0.00 0.00 -1,041.68 -1,041.68 -1,041.68

[Guido Geurs]

dear,

What is your question ??
What want you to do with the data???


br,

[VBhelpalwayswanted]

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 be very much appreciated

Thanks

Jason