Mark Goodridge1
New Member
- Joined
- May 19, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have two tabs within my workbook:
DataSheet - contains a lookupcode (department number & account description & month) and an £ amount column and has thousands of rows of data
Report Sheet - this contains account descriptions in the first column (e.g. venue hire, catering, etc.) and months across the rows (Apr-Mar)
My query is how to combine the department number + account description + month and then sum up all of the relevant transactions from the DataSheet, with the ability to replicate this for each month and account description
Many thanks in advance
I have two tabs within my workbook:
DataSheet - contains a lookupcode (department number & account description & month) and an £ amount column and has thousands of rows of data
Report Sheet - this contains account descriptions in the first column (e.g. venue hire, catering, etc.) and months across the rows (Apr-Mar)
My query is how to combine the department number + account description + month and then sum up all of the relevant transactions from the DataSheet, with the ability to replicate this for each month and account description
Many thanks in advance