Sorting

B

bert505

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

Data
Date................Name.............Result
01/02/2012......Jean...............1
01/02/2012.......Paul...............
01/02/2012.......Jean..............-
01/02/2012.......Pierre............-
O2/02/2012.......Jean.............-
02/02/2012.......Pierre............1
et
My problem : sort that datas (up to 1000 lines !
By dat
01/02/2012... Negative.... Positive.... Net.... Ratio(Pos/Neg
02/02/2012..
By nam
Jean.............. Negative.... Positive.... Net.... Ratio (Pos/Neg
Pierre...
And the VBA code to do that..
Thanks Everyon

(this site is amazing but so hudge... that it is difficult to fin
something

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

bert505

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 browse
(thks J. Wallenbach), transform CSV files to xls files throug
delimiters, wipe some unnecessary columns, transform some "crazy" data
to numeric data... not bad..
But I need your help... to "transform my data
a/ Pivot is not a way coz not possible to sort neg value / pos valu
(>=, <=
b/ Old way
Set value in Day1 variable of Range A
While row is not "
Search next occurence of value Day
Set value in Day2 of this positio
(Trap error if value Day1 = value Day2
Select Are
Sumif of area(C) >=
Store value in variable
Sumif of area (C) <= C
Store value in variable
Now put these values in new sheet + calculations (y-x and x/y
Back in first shee
Day1=Day2+
Wen
Some errors errors.. perhaps.. but globally is tha
 
Top