How to auto sum with irregualr rows with existing formula and bold it and draw lines

[ec4excel]

I really need help from the experts here.

I have a file with many different row sizes and after calculating the figure, we will need to add up the total for a particular job. Due to the irregular data on each job (some with only 1 line item where sometimes the job have few line items).

The cell to sum already has a formula for the data.

For example, I already have a formula on Column L to get the figures. After few line items, I will need to add a total to the lines item, also on Column L. I think we can uses 2 sets of data from 2 different column as "pointers", Column D and the formula column itself (but I don't know how to). The columns that I need a sum function will be from Column L to X. After doing the sum, can we at the same time draw a sum line? (single top line and double bottom line).

Am I being "too greedy" ? Imagine if we have more than thousands lines of such data to be added manually and to draw these lines manually.

[p24leclerc]

I think you will need a macro to do this. Is it something you are confortable with?

[ec4excel]

Yes, so long as can solve the problem.

[ec4excel]

Portion of the issues were solved in the link below, therefore, closed this thread.

http://www.excelforum.com/excel-form...ml#post3611287