|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need help with Sorting and adding cells, it sound basis however it is more complicated than that.
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 |
#2
|
||||
|
||||
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)
__________________
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 |
#3
|
|||
|
|||
Thank You. I'll give it a crack.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns | innkeeper9 | Excel | 5 | 08-30-2016 04:43 PM |
Sorting cells alphabetically | jenpen | Word | 5 | 11-16-2015 11:35 PM |
Linking cells: can sub-cells move with their master-cell when sorting? | kw01 | Excel | 1 | 06-30-2015 05:02 PM |
Table will not allow sorting because "cells are merged". I can't find the merged cells. | wendyloooo | Word Tables | 1 | 05-26-2015 01:19 PM |
Adding Sound | harkawy | PowerPoint | 0 | 02-22-2010 04:52 PM |