D
djforgone
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....
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....