Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2017, 03:36 AM
will soar will soar is offline I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Windows 10 I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Office 2013
Novice
I need help with Sorting and adding cells, it sound basis however it is more complicated than that.
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Cool 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
Reply With Quote
  #2  
Old 02-23-2017, 05:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Windows 7 64bit I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-23-2017, 01:38 PM
will soar will soar is offline I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Windows 10 I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Office 2013
Novice
I need help with Sorting and adding cells, it sound basis however it is more complicated than that.
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Default

Thank You. I'll give it a crack.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns innkeeper9 Excel 5 08-30-2016 04:43 PM
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Sorting cells alphabetically jenpen Word 5 11-16-2015 11:35 PM
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
I need help with Sorting and adding cells, it sound basis however it is more complicated than that. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft