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

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