create subtotals and copy subtotals to a new sheet with VBA

**tonupgirl** · 07-06-2012, 03:38 AM

Hallo,

I have got a table in Excel witch I want to sort on column Sortering and add subtotals when the value in the column sortering changes. Hereafter the subtotals have to be copied to on existing sheet in the workbook.

I attach several print screens of the situations.

Thanks.

Working with Excel 2010.

**arlu1201** · 07-06-2012, 03:41 AM

Please attach a sample excel file instead of screenshots.

**tonupgirl** · 07-06-2012, 04:17 AM

I attached the original Excel file.

**arlu1201** · 07-06-2012, 06:07 AM

Should the subtotals be created for each numerical field in your sheet Artikelen?

Also should the subtotals be created for other sheets in your file?

Where should the subtotals be copied to?

Which columns containing the subtotals should be copied? All?

**tonupgirl** · 07-09-2012, 01:36 AM

Good morning Arlette,

1) Subtotals should be created in the columns D, E, F, G, H, J, K, L, N, O, P, Q, R. The columns D, G, N, P, Q should only show unique values, the other columns should show totals.
2) No only subtotals should be created from sheet Artikelen to Invoice_hulp.
3) The subtotals should be copied to Invoice_Hulp2.
4) All

Hope this helps.

Brigitte