View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] djforgone@gmail.com is offline
external usenet poster
 
Posts: 3
Default SQL data from VBA - Sort into groups via heading.

Hi Everyone...

I am trying to figure out how to go about doing this.
I want to build an Excel Finance Reporting Template that will import GL transactions from an Access Database based on a cost center.

Thus Cost Centre in spreadsheet = Cost Center in Excel loop.

That part I've done before and just need to manipulate the code for it to make it work.

What I need assistance with is how to 'group' the transactions that are being obtained from GL table in Access by heading.

For example:

H1 = EMPLOYEE BENEFITS EXPENSE
-
- rows relating to employee benefits expense here -
-
-

H1 = SUPPLIES AND SERVICES
-
- rows relating to supplies and services here -
-
-

and so forth....