Autosum

Hi,

I have a code that looks at separates blocks of distinct cells with an empty line, then inserts a Autosum formula in that line and indicates that it is a subtotal.

My problem is that instead of auto-summing the numbers corresponding to the distinct block of cells, it sum formula extends to the top of the spreadsheet?

Besides that problem, is there a smarter way I could write this macro?

Thanks in advance!!

Please Login or Register  to view this content.

Quite possibly. I suggest you attach a small sample workbook illustrating how your data are arranged and your desired results.

File attached!

Basically it separates the data based on the code in column A and subtotals it, the loops through each tab (normally there are ~50 tabs)

However, each subtotal reaches to the top of the spreadsheet.

Try this. I had to put in some dummy data as you have some odd formatting.

Please Login or Register  to view this content.

Originally Posted by StephenR

Try this. I had to put in some dummy data as you have some odd formatting.

You've successfully taken my clunker code and turned it into a new model!!

one again, I really appreciate your help... ur too good!

Originally Posted by StephenR

Try this. I had to put in some dummy data as you have some odd formatting.

Quick question, how would I bold and create a line above each subtotal line ??

Try this. On reflection, you could have used Excel's built-in Subtotal feature.

Please Login or Register  to view this content.

Originally Posted by StephenR

Try this. On reflection, you could have used Excel's built-in Subtotal feature.

Worked perfectly.. if i was wearing a hat, I would tip it to you, then give it to you :P

Yes, I tried to implement the autosum feature, but I couldn't do it properly. I'm still learning!