Hi



13/02 All Season Flowers 21
13/02 CASH 20
14/02 CASH 50
15/02 Just Eat 20.98
16/02 McDonald's 5.8
16/02 B&Q 15
17/02 CASH 40
18/02 DAA 2
19/02 CASH 57.2
21/02 Heritage Park 23

So what i would like to be able to do is take all CASH dates and values and have them copied to another sheet or section on the same sheet. I would like to have a total in area at bottom. I would also like that every time CASH is entered it is automatically copied to the CASH calculation area.
I'd be grateful if someone can tell me how to make this happen.

TY

Will

Hi
make a table of your range than use it as data source for a Pivot Table filtered on the string CASH.
You can refersh manually or by adding a small macro triggered by some event ( you can find this technique on the Net)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank You. I'll give it a crack.