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
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