sobeitjedi
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 235
- Office Version
- 365
Hi.
I have a single, simple Excel sheet but I'm not sure how to present the data. To simplify, the data looks like ...
CostCentre | TransactionDate | UserName | Cost | Cost Centre Owner
abc1 | 01/01/18 | John.Smith| 0.72 | Jim.Jones
abc2 | 02/01/18 | John.Smith | 0.13 | Cat.Smith
abc3 | 02/01/18 | Bella.Williams | 0.26 | Jim.Jones
This month, there's over 27,000 rows in this sheet
What I'd like to do ultimately, is email each cost centre owner (there's about 70 cost centre owners, each owner can have one or more code), telling them who has charged to their cost centre(s) this month.
How can I achieve this?
I have a single, simple Excel sheet but I'm not sure how to present the data. To simplify, the data looks like ...
CostCentre | TransactionDate | UserName | Cost | Cost Centre Owner
abc1 | 01/01/18 | John.Smith| 0.72 | Jim.Jones
abc2 | 02/01/18 | John.Smith | 0.13 | Cat.Smith
abc3 | 02/01/18 | Bella.Williams | 0.26 | Jim.Jones
This month, there's over 27,000 rows in this sheet
What I'd like to do ultimately, is email each cost centre owner (there's about 70 cost centre owners, each owner can have one or more code), telling them who has charged to their cost centre(s) this month.
How can I achieve this?