Help with Suming of Column
 

I need VBA code to sum the values in two columns even if the data is each set
that I need to sum varies in length exa.

Initial data

Quantity Amount
2 32.30

3 177.00

2 1,598.00
2 198.00

End result needed.

Quantity Amount
2 32.30
2 32.30 The sum of values above

3 177.00
3 177.00 The sum of values above


2 1,598.00
2 198.00
4 1,796.00 The sum of values above

I need it to do this until the end of the data..
Any help Would be deeply appreciated..

--
Regards,
Michael

Help with Suming of Column
 

Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data Subtotal Follow the instructions

Hopes this helps.

---
Per

"Michael from Austin" skrev i
meddelelsen ...
I need VBA code to sum the values in two columns even if the data is each
set
that I need to sum varies in length exa.

Initial data

Quantity Amount
2 32.30

3 177.00

2 1,598.00
2 198.00

End result needed.

Quantity Amount
2 32.30
2 32.30 The sum of values above

3 177.00
3 177.00 The sum of values above


2 1,598.00
2 198.00
4 1,796.00 The sum of values above

I need it to do this until the end of the data..
Any help Would be deeply appreciated..

--
Regards,
Michael

Help with Suming of Column
 

Wow. didn't think the subtotal would work because I have empty rows
seperating them. It worked though. I feel like an idiot. Thanks for you help.
Sometimes the answer is staring you in the face:)
--
Regards,
Michael


"Per Jessen" wrote:

Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data Subtotal Follow the instructions

Hopes this helps.

---
Per

"Michael from Austin" skrev i
meddelelsen ...
I need VBA code to sum the values in two columns even if the data is each
set
that I need to sum varies in length exa.

Initial data

Quantity Amount
2 32.30

3 177.00

2 1,598.00
2 198.00

End result needed.

Quantity Amount
2 32.30
2 32.30 The sum of values above

3 177.00
3 177.00 The sum of values above


2 1,598.00
2 198.00
4 1,796.00 The sum of values above

I need it to do this until the end of the data..
Any help Would be deeply appreciated..

--
Regards,
Michael

Help with Suming of Column
 

Thanks for the help. It worked...
--
Regards,
Michael


"Per Jessen" wrote:

Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data Subtotal Follow the instructions

Hopes this helps.

---
Per

"Michael from Austin" skrev i
meddelelsen ...
I need VBA code to sum the values in two columns even if the data is each
set
that I need to sum varies in length exa.

Initial data

Quantity Amount
2 32.30

3 177.00

2 1,598.00
2 198.00

End result needed.

Quantity Amount
2 32.30
2 32.30 The sum of values above

3 177.00
3 177.00 The sum of values above


2 1,598.00
2 198.00
4 1,796.00 The sum of values above

I need it to do this until the end of the data..
Any help Would be deeply appreciated..

--
Regards,
Michael