#1   Report Post  
Old April 9th 12, 03:35 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 2
Default Sorting

Hi Everyone
New on this Forum
Sure that this kind of stuff have been already... I apologize...
I was on XP Office 2003 and Macro Excel 4
Laptop died... Now W7 Office 2010 and starting to learn VBA...

Datas
Date................Name.............Results
01/02/2012......Jean...............10
01/02/2012.......Paul...............5
01/02/2012.......Jean..............-5
01/02/2012.......Pierre............-5
O2/02/2012.......Jean.............-5
02/02/2012.......Pierre............10
etc
My problem : sort that datas (up to 1000 lines !)
By date
01/02/2012... Negative.... Positive.... Net.... Ratio(Pos/Neg)
02/02/2012...
By name
Jean.............. Negative.... Positive.... Net.... Ratio (Pos/Neg)
Pierre....
And the VBA code to do that...
Thanks Everyone
B
(this site is amazing but so hudge... that it is difficult to find something)

PS I already tried Pivot Table : I can't insert =0 or =0 inside Pivot to have a column for negative values /positive values

Last edited by bert505 : April 9th 12 at 03:43 PM Reason: More...

  #2   Report Post  
Old April 10th 12, 11:54 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 2
Default

Hi Guys,
My point is : I dont know how to SPEAK/WRITE VBA!!!
I started VBA 10 days ago and I am half way : select files by browser (thks J. Wallenbach), transform CSV files to xls files through delimiters, wipe some unnecessary columns, transform some "crazy" datas to numeric data... not bad...
But I need your help... to "transform my datas
a/ Pivot is not a way coz not possible to sort neg value / pos value (=, <=)
b/ Old way :
Set value in Day1 variable of Range A1
While row is not ""
Search next occurence of value Day1
Set value in Day2 of this position
(Trap error if value Day1 = value Day2)
Select Area
Sumif of area(C) =
Store value in variable X
Sumif of area (C) <= C
Store value in variable Y
Now put these values in new sheet + calculations (y-x and x/y)
Back in first sheet
Day1=Day2+1
Wend
Some errors errors.. perhaps.. but globally is that


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Values Without Sorting Formulas SBX Excel Discussion (Misc queries) 2 April 12th 09 11:17 PM
Automatic sorting (giving max and min) based on custom sorting lis Joe Lewis[_2_] Excel Worksheet Functions 4 November 23rd 08 06:12 AM
Sorting VLookup vs Sorting SumProduct Lauren Excel Discussion (Misc queries) 1 August 21st 07 12:19 AM
Sorting: Sorting by the First Character dzuy Excel Discussion (Misc queries) 2 June 22nd 06 08:27 PM
Sorting ListBox results or transposing ListBox values to other cells for sorting Rob[_8_] Excel Programming 1 July 9th 03 04:35 AM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017