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