Sum columns

[mdavontuur25]

Hi Everyone

I have an spreadsheet with multiple columns. Column "F" is called Debit and column "G" Credit then Column "H" is and accumalative Column.

Ideally I want the macro to sumtract anything in the debit column and add what is in the credit column to give the cummulative figure.

eg. 100 (Debit) + 0 (Credit) = -100 (Cummulative)
0 (Debit) + 600 (Credit) = 500 (Commulative)

at the end the macro must put the total Cummulative amount in either the Debit column (if " - ") or the credit column (if "+") and place a single line above and a double line at the bottom.

I hope this makes sense

 

[Glory]

I'm not sure what you mean when you say "a single line above" and "a double line at the bottom".

 

[Airwolf]

Why a macro - won't formula dothis easily for you???

 

[Lizzielady]

Think they mean borders, they want the cell to format to a top border and a bottom double border

 

[mdavontuur25]

The sheet is created from a macro so I can only add this functionality after the macro are created, therefore it has to be in a macro.

Single line refers to a line with a normal width (not a thick black line)
and double line refers to normal line width that looks like a equal sign.

Thanks

 

[Glory]

You could actually insert a formula into the sheet using the same macro that creates the sheet. If you post your code somebody might be able to help you out. It would help if you pasted in a couple tables that show the layout of the source data too.