subtotals and totals

[Dharmesh]

hello

i have a database which creates excel files from queries. Is it possible using some coding to add subtotals and totals to the excel file. I want to add subtotals so that when a department changes, a subtotal is added and then a total is added.

Dharmesh

 

[llkhoutx]

Sounds like you're trying to use Excel as a database program. Access does this querying, grouping and totaling quite handily.

If you must do it in Excel integrate additional queries into you Excel sheet.

 

[HaHoBe]

Hi, Dharmesh,

if the database is sorted in the wanted order, use Data / Subtotals or a pivot table.

Ciao,
Holger