I'm not sure whether I am intrepreting what you want correctly. I thin
you want to create subtotals on each page and then copy the subtotals a
the bottom of the page.
For each worksheet you could:
1. create the subtotals - use absolute cell references, specify Jan-De
columns
2. loop through the rows to find the last row (loop until empty)
3. loop through the rows again and copy each subtotal row below th
last row (remember that the bottom row is one greater for each row yo
copy)
The biggest hindrance I can think of is that you need a listing of yo
worksheets so that you can have the macro go to each worksheet. If yo
need help with the code, I'll have to catch you tomorrow. I'm about t
go home. I hope that was at least a little helpful. I'm new t
forums, so please give me a break if I'm not doing this right. Goo
luck
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
